Spreadsheet: 674879d1588065838-sumif-formula-returning-0-sample-book
Sheet: Sheet1

Day Cat | number of days | Amount
 | 51 | 200
 | 51 | 1000
 | 51 | 2500 |  |  |  |  |  |  |  |  | <=30 | >30<=89 | =>90 | Target Line
 | 51 | 300
 | 51 | 800 |  |  |  |  |  |  |  | 1 | 239 | 65 | 376 | 200
 | 51 | 400 |  |  |  |  |  |  |  | 2 | 215 | 111 | 377 | 200
 | 51 | 900 |  |  |  |  |  |  |  | 3 | 222 | 104 | 381 | 200
 | 51 | 1500 |  |  |  |  |  |  |  | 4 | 212 | 107 | 380 | 200
 | 51 | 1200 |  |  |  |  |  |  |  | 5 | 226 | 107 | 379 | 200
 | 51 | 1400 |  |  |  |  |  |  |  | 6 | 224 | 106 | 381 | 200
 | 51 | 500 |  |  |  |  |  |  |  | 7 | 287 | 100 | 380 | 200
 | 20 | 300 |  |  |  |  |  |  |  | 8 | 317 | 93 | 380 | 200
 | 20 | 700 |  |  |  |  |  |  |  | 9 | 292 | 94 | 380 | 200
 | 20 | 900 |  |  |  |  |  |  |  | 10 | 310 | 95 | 380 | 200
 | 20 | 2805 |  |  |  |  |  |  |  | 11 | 316 | 95 | 380 | 200
 | 20 | 2480 |  |  |  |  |  |  |  | 12 | 365 | 95 | 380 | 200
 | 20 | 2111 |  |  |  |  |  |  |  | 13 | 383 | 95 | 380 | 200
 | 20 | 2331 |  |  |  |  |  |  |  | 14 | 352 | 94 | 380 | 200
 | 20 | 200 |  |  |  |  |  |  |  | 15 | 413 | 83 | 380 | 200
 | 20 | 400 |  |  |  |  |  |  |  | 16 | 474 | 73 | 383 | 200
 | 20 | 800 |  |  |  |  |  |  |  | 17 | 435 | 70 | 383 | 200
 | 20 | 600 |  |  |  |  |  |  |  | 18 | 339 | 122 | 383 | 200
 | 356 | 700 |  |  |  |  |  |  |  | 19 | 373 | 123 | 384 | 200
 | 356 | 2345 |  |  |  |  |  |  |  | 20 | 356 | 123 | 384 | 200
 | 325 | 2689 |  |  |  |  |  |  |  | 21 |  |  |  | 200
 | 295 | 2458 |  |  |  |  |  |  |  | 22 |  |  |  | 200
 | 295 | 656 |  |  |  |  |  |  |  | 23 |  |  |  | 200
 | 295 | 960 |  |  |  |  |  |  |  | 24 |  |  |  | 200
 | 295 | 998 |  |  |  |  |  |  |  | 25 |  |  |  | 200
 | 295 | 1012 |  |  |  |  |  |  |  | 26 |  |  |  | 200
 | 203 | 2356 |  |  |  |  |  |  |  | 27 |  |  |  | 200
 | 110 | 2755 |  |  |  |  |  |  |  | 28 |  |  |  | 200
 | 110 | 2405 |  |  |  |  |  |  |  | 29 |  |  |  | 200
 | 110 | 2431 |  |  |  |  |  |  |  | 30 |  |  |  | 200
 | 110 | 645 |  |  |  |  |  |  |  | 31 |  |  |  | 200
 | 110 | 875 |  |  |  |  |  |  |  | Total
 | 110 | 961
 | 110 | 2456
 | 110 | 633
 | 110 | 856
 | 110 | 944
 | 110 | 2700
 | 110 | 2604
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0