Spreadsheet: 733642d1621678964-sumifs-returning-0-and-i-cant-see-why-sample
Sheet: Jan

 | Store | Units | Date
 | 555 | 34 | 2021-01-30 00:00:00
 | 555 | 37 | 2021-01-30 00:00:00
 | 555 | 32 | 2021-01-30 00:00:00
 | 555 | 56 | 2021-01-30 00:00:00
 | 555 | 14 | 2021-01-30 00:00:00
 | 555 | 102 | 2021-01-30 00:00:00
 | 555 | 72 | 2021-01-30 00:00:00
 | 555 | 29 | 2021-01-30 00:00:00
 | 555 | 51 | 2021-01-30 00:00:00
 | 555 | 21 | 2021-01-30 00:00:00
 | 555 | 4 | 2021-01-30 00:00:00
 | 555 | 75 | 2021-01-16 00:00:00
 | 555 | 39 | 2021-01-30 00:00:00
 | 555 | 75 | 2021-01-30 00:00:00
 | 555 | 106 | 2021-01-30 00:00:00
 | 555 | 52 | 2021-01-30 00:00:00
 | 555 | 73 | 2021-01-30 00:00:00
 | 555 | 116 | 2021-01-30 00:00:00
 | 555 | 82 | 2021-01-30 00:00:00
 | 555 | 95 | 2021-01-30 00:00:00
 | 555 | 96 | 2021-01-30 00:00:00
 | 555 | 63 | 2021-01-30 00:00:00
 | 555 | 109 | 2021-01-30 00:00:00
 | 555 | 78 | 2021-01-30 00:00:00
 | 555 | 23 | 2021-01-21 00:00:00
 | 555 | 2 | 2021-01-29 00:00:00
 | 555 | 10 | 2021-01-29 00:00:00
 | 555 | 15 | 2021-01-28 00:00:00
 | 555 |  | 2021-01-28 00:00:00
 | 555 | 4 | 2021-01-28 00:00:00
 | 555 | 8 | 2021-01-29 00:00:00
 | 555 | 7 | 2021-01-29 00:00:00
 | 555 | 57 | 2021-01-28 00:00:00
 | 555 | 11 | 2021-01-28 00:00:00
 | 555 | 5 | 2021-01-28 00:00:00
 | 555 | 7 | 2021-01-28 00:00:00
 | 555 | 3 | 2021-01-28 00:00:00
 | 555 | 6 | 2021-01-28 00:00:00
 | 555 | 16 | 2021-01-28 00:00:00
 | 555 | 13 | 2021-01-29 00:00:00
 | 555 | 6 | 2021-01-30 00:00:00
 | 555 | 13 | 2021-01-30 00:00:00
 | 555 | 23 | 2021-01-30 00:00:00
 | 555 | 7 | 2021-01-30 00:00:00
 | 555 | 16 | 2021-01-30 00:00:00
 | 555 | 6 | 2021-01-30 00:00:00
 | 555 | 4 | 2021-01-29 00:00:00
 | 555 | 4 | 2021-01-30 00:00:00
 | 555 | 8 | 2021-01-29 00:00:00
 | 555 | 42 | 2021-01-29 00:00:00
 | 555 | 4 | 2021-01-29 00:00:00
 | 555 | 6 | 2021-01-30 00:00:00
 | 555 | 2 | 2021-01-29 00:00:00
 | 555 | 16 | 2021-01-30 00:00:00
 | 555 | 34 | 2021-01-29 00:00:00
 | 555 | 6 | 2021-01-29 00:00:00
 | 555 | 104 | 2021-01-29 00:00:00
 | 555 | 2 | 2021-01-30 00:00:00
 | 555 | 3 | 2021-01-30 00:00:00
 | 555 | 5 | 2021-01-30 00:00:00
 | 555 | 4 | 2021-01-30 00:00:00
 | 555 | 10 | 2021-01-30 00:00:00
 | 555 | 6 | 2021-01-30 00:00:00
 | 555 | 5 | 2021-01-30 00:00:00
 | 555 | 28 | 2021-01-30 00:00:00
 | 555 | 58 | 2021-01-30 00:00:00
 | 555 | 15 | 2021-01-30 00:00:00
 | 555 | 102 | 2021-01-30 00:00:00
 | 555 | 39 | 2021-01-30 00:00:00
 | 555 | 9 | 2021-01-30 00:00:00
 | 556 | 2 | 2021-01-23 00:00:00
 | 556 | 67 | 2021-01-23 00:00:00
 | 556 | 16 | 2021-01-23 00:00:00
 | 556 | 10 | 2021-01-23 00:00:00
 | 556 | 8 | 2021-01-23 00:00:00
 | 556 | 10 | 2021-01-23 00:00:00
 | 556 | 8 | 2021-01-23 00:00:00
 | 556 | 2 | 2021-01-23 00:00:00
 | 556 | 8 | 2021-01-23 00:00:00
 | 556 | 166 | 2021-01-23 00:00:00
 | 556 | 90 | 2021-01-23 00:00:00
 | 556 | 61 | 2021-01-23 00:00:00
 | 556 | 24 | 2021-01-23 00:00:00
 | 556 | 26 | 2021-01-23 00:00:00
 | 556 | 53 | 2021-01-23 00:00:00
 | 556 | 5 | 2021-01-23 00:00:00
 | 556 | 22 | 2021-01-23 00:00:00
 | 556 | 59 | 2021-01-23 00:00:00
 | 556 | 51 | 2021-01-23 00:00:00
 | 556 | 17 | 2021-01-23 00:00:00
 | 556 | 6 | 2021-01-23 00:00:00
 | 556 | 5 | 2021-01-23 00:00:00
 | 556 | 5 | 2021-01-23 00:00:00
 | 556 | 24 | 2021-01-30 00:00:00
 | 556 | 76 | 2021-01-30 00:00:00
 | 556 | 86 | 2021-01-30 00:00:00
 | 556 | 72 | 2021-01-30 00:00:00
 | 556 | 44 | 2021-01-23 00:00:00
 | 556 | 36 | 2021-01-23 00:00:00
 | 556 | 68 | 2021-01-23 00:00:00
 | 556 | 36 | 2021-01-23 00:00:00
 | 556 | 59 | 2021-01-23 00:00:00
 | 556 | 9 | 2021-01-23 00:00:00
 | 556 | 45 | 2021-01-23 00:00:00
 | 556 | 38 | 2021-01-23 00:00:00
 | 556 | 42 | 2021-01-23 00:00:00
 | 556 | 106 | 2021-01-23 00:00:00
 | 556 | 35 | 2021-01-23 00:00:00
 | 556 | 60 | 2021-01-23 00:00:00
 | 556 | 70 | 2021-01-23 00:00:00
 | 556 | 99 | 2021-01-23 00:00:00
 | 556 | 73 | 2021-01-23 00:00:00
 | 556 | 59 | 2021-01-23 00:00:00
 | 556 | 43 | 2021-01-23 00:00:00
 | 556 | 29 | 2021-01-23 00:00:00
 | 556 | 50 | 2021-01-23 00:00:00
 | 556 | 59 | 2021-01-23 00:00:00
 | 556 | 61 | 2021-01-23 00:00:00
 | 556 | 43 | 2021-01-23 00:00:00
 | 556 | 72 | 2021-01-23 00:00:00
 | 556 | 38 | 2021-01-23 00:00:00
 | 556 | 76 | 2021-01-23 00:00:00
 | 556 | 16 | 2021-01-23 00:00:00
 | 556 | 166 | 2021-01-23 00:00:00
 | 556 | 95 | 2021-01-23 00:00:00
 | 556 | 55 | 2021-01-23 00:00:00
 | 556 | 93 | 2021-01-23 00:00:00
 | 556 | 42 | 2021-01-23 00:00:00
 | 556 | 99 | 2021-01-23 00:00:00
 | 556 | 104 | 2021-01-23 00:00:00
 | 556 | 173 | 2021-01-23 00:00:00
 | 556 | 51 | 2021-01-23 00:00:00
 | 556 | 52 | 2021-01-23 00:00:00
 | 556 | 49 | 2021-01-23 00:00:00
 | 556 | 51 | 2021-01-23 00:00:00
 | 556 | 77 | 2021-01-23 00:00:00
 | 556 | 21 | 2021-01-23 00:00:00
 | 556 | 46 | 2021-01-23 00:00:00
 | 556 | 16 | 2021-01-23 00:00:00
 | 556 | 36 | 2021-01-23 00:00:00
 | 556 | 21 | 2021-01-23 00:00:00
 | 556 | 59 | 2021-01-23 00:00:00
 | 556 | 32 | 2021-01-23 00:00:00
 | 556 | 18 | 2021-01-23 00:00:00
 | 556 | 78 | 2021-01-23 00:00:00
 | 556 | 20 | 2021-01-01 00:00:00
 | 556 | 2 | 2021-01-01 00:00:00
 | 556 | 5 | 2021-01-01 00:00:00
 | 556 | 12 | 2021-01-01 00:00:00
 | 556 | 9 | 2021-01-01 00:00:00
 | 556 | 5 | 2021-01-01 00:00:00
 | 556 | 8 | 2021-01-01 00:00:00
 | 556 | 34 | 2021-01-01 00:00:00
 | 556 | 24 | 2021-01-06 00:00:00
 | 556 | 5 | 2021-01-02 00:00:00
 | 556 | 17 | 2021-01-02 00:00:00
 | 556 | 17 | 2021-01-02 00:00:00
 | 556 | 54 | 2021-01-02 00:00:00
 | 556 | 12 | 2021-01-07 00:00:00
 | 556 | 10 | 2021-01-02 00:00:00
 | 556 | 30 | 2021-01-02 00:00:00
 | 556 | 2 | 2021-01-06 00:00:00
 | 556 | 15 | 2021-01-06 00:00:00
 | 556 | 18 | 2021-01-06 00:00:00
 | 556 | 18 | 2021-01-06 00:00:00
 | 556 | 4 | 2021-01-07 00:00:00
 | 556 | 1 | 2021-01-07 00:00:00
 | 556 | 11 | 2021-01-07 00:00:00
 | 556 | 2 | 2021-01-07 00:00:00
 | 556 | 4 | 2021-01-08 00:00:00
 | 556 | 7 | 2021-01-08 00:00:00
 | 556 | 2 | 2021-01-08 00:00:00
 | 556 | 15 | 2021-01-08 00:00:00
 | 556 | 8 | 2021-01-08 00:00:00
 | 556 | 10 | 2021-01-09 00:00:00
 | 556 | 2 | 2021-01-09 00:00:00
 | 556 | 4 | 2021-01-09 00:00:00
 | 556 | 14 | 2021-01-09 00:00:00
 | 556 | 4 | 2021-01-09 00:00:00
 | 556 | 2 | 2021-01-09 00:00:00
 | 556 | 36 | 2021-01-14 00:00:00
 | 556 | 14 | 2021-01-13 00:00:00
 | 556 | 3 | 2021-01-14 00:00:00
 | 556 | 28 | 2021-01-14 00:00:00
 | 556 | 4 | 2021-01-14 00:00:00
 | 556 | 35 | 2021-01-15 00:00:00
 | 556 | 4 | 2021-01-15 00:00:00
 | 556 | 9 | 2021-01-15 00:00:00
 | 556 | 55 | 2021-01-15 00:00:00
 | 556 | 18 | 2021-01-15 00:00:00
 | 556 | 16 | 2021-01-15 00:00:00
 | 556 | 47 | 2021-01-15 00:00:00
 | 556 | 39 | 2021-01-15 00:00:00
 | 556 | 31 | 2021-01-16 00:00:00
 | 556 | 34 | 2021-01-15 00:00:00
 | 556 | 35 | 2021-01-15 00:00:00
 | 556 | 8 | 2021-01-15 00:00:00
 | 556 | 13 | 2021-01-15 00:00:00
 | 556 | 19 | 2021-01-15 00:00:00
 | 556 | 9 | 2021-01-16 00:00:00
 | 556 | 70 | 2021-01-15 00:00:00
 | 556 | 37 | 2021-01-15 00:00:00
 | 556 | 19 | 2021-01-15 00:00:00
 | 556 | 13 | 2021-01-16 00:00:00
 | 556 | 19 | 2021-01-15 00:00:00
 | 556 | 20 | 2021-01-16 00:00:00
 | 556 | 7 | 2021-01-16 00:00:00
 | 556 | 4 | 2021-01-15 00:00:00
 | 556 | 20 | 2021-01-16 00:00:00
 | 556 | 6 | 2021-01-15 00:00:00
 | 556 | 1 | 2021-01-15 00:00:00
 | 556 | 1 | 2021-01-16 00:00:00
 | 556 | 6 | 2021-01-16 00:00:00
 | 556 | 2 | 2021-01-15 00:00:00
 | 556 | 8 | 2021-01-15 00:00:00
 | 556 | 6 | 2021-01-16 00:00:00
 | 556 | 12 | 2021-01-20 00:00:00
 | 556 | 12 | 2021-01-20 00:00:00
 | 556 | 63 | 2021-01-20 00:00:00
 | 556 | 12 | 2021-01-20 00:00:00
 | 556 | 19 | 2021-01-20 00:00:00
 | 556 | 22 | 2021-01-21 00:00:00
 | 556 | 37 | 2021-01-20 00:00:00
 | 556 | 54 | 2021-01-21 00:00:00
 | 556 | 2 | 2021-01-22 00:00:00
 | 556 | 11 | 2021-01-21 00:00:00
 | 556 | 4 | 2021-01-21 00:00:00
 | 556 | 28 | 2021-01-21 00:00:00
 | 556 | 1 | 2021-01-21 00:00:00
 | 556 | 53 | 2021-01-21 00:00:00
 | 556 | 5 | 2021-01-21 00:00:00
 | 556 | 2 | 2021-01-21 00:00:00
 | 556 | 4 | 2021-01-21 00:00:00
 | 556 | 2 | 2021-01-22 00:00:00
 | 556 | 6 | 2021-01-21 00:00:00
 | 556 | 8 | 2021-01-22 00:00:00
 | 556 | 5 | 2021-01-21 00:00:00
 | 556 | 3 | 2021-01-21 00:00:00
 | 556 | 18 | 2021-01-21 00:00:00
 | 556 | 27 | 2021-01-21 00:00:00
 | 556 | 52 | 2021-01-22 00:00:00
 | 556 | 20 | 2021-01-22 00:00:00
 | 556 | 12 | 2021-01-22 00:00:00
 | 556 | 18 | 2021-01-23 00:00:00
 | 556 | 25 | 2021-01-22 00:00:00
 | 556 | 3 | 2021-01-23 00:00:00
 | 556 | 12 | 2021-01-22 00:00:00
 | 556 | 2 | 2021-01-22 00:00:00
 | 556 | 4 | 2021-01-23 00:00:00
 | 556 | 4 | 2021-01-22 00:00:00
 | 556 | 16 | 2021-01-22 00:00:00
 | 556 | 6 | 2021-01-22 00:00:00
 | 556 | 7 | 2021-01-22 00:00:00
 | 556 | 6 | 2021-01-22 00:00:00
 | 556 | 10 | 2021-01-23 00:00:00
 | 556 | 1 | 2021-01-22 00:00:00
 | 556 | 15 | 2021-01-22 00:00:00
 | 556 | 3 | 2021-01-22 00:00:00
 | 556 | 12 | 2021-01-22 00:00:00
 | 556 | 21 | 2021-01-22 00:00:00
 | 556 | 12 | 2021-01-22 00:00:00
 | 556 | 3 | 2021-01-22 00:00:00
 | 556 | 7 | 2021-01-22 00:00:00
 | 556 | 24 | 2021-01-26 00:00:00
 | 556 | 15 | 2021-01-22 00:00:00
 | 556 | 19 | 2021-01-22 00:00:00
 | 556 | 9 | 2021-01-22 00:00:00
 | 556 | 5 | 2021-01-22 00:00:00
 | 556 | 21 | 2021-01-22 00:00:00
 | 556 | 34 | 2021-01-22 00:00:00
 | 556 | 27 | 2021-01-23 00:00:00
 | 556 | 35 | 2021-01-22 00:00:00
 | 556 | 26 | 2021-01-23 00:00:00
 | 556 | 3 | 2021-01-22 00:00:00
 | 556 | 27 | 2021-01-23 00:00:00
 | 556 | 1 | 2021-01-23 00:00:00
 | 556 | 9 | 2021-01-23 00:00:00
 | 556 | 4 | 2021-01-23 00:00:00
 | 556 | 2 | 2021-01-23 00:00:00
 | 556 | 3 | 2021-01-23 00:00:00
 | 556 | 17 | 2021-01-23 00:00:00
 | 556 | 4 | 2021-01-23 00:00:00
 | 556 | 13 | 2021-01-23 00:00:00
 | 556 | 36 | 2021-01-23 00:00:00
 | 556 | 34 | 2021-01-23 00:00:00
 | 556 | 7 | 2021-01-23 00:00:00
 | 556 | 5 | 2021-01-23 00:00:00
 | 556 | 2 | 2021-01-23 00:00:00
 | 556 | 4 | 2021-01-23 00:00:00
 | 556 | 37 | 2021-01-23 00:00:00
 | 556 | 14 | 2021-01-29 00:00:00
 | 556 | 25 | 2021-01-29 00:00:00
 | 556 | 3 | 2021-01-29 00:00:00
 | 556 | 10 | 2021-01-26 00:00:00
 | 556 | 4 | 2021-01-29 00:00:00
 | 556 | 43 | 2021-01-26 00:00:00
 | 556 | 8 | 2021-01-27 00:00:00
 | 556 | 28 | 2021-01-27 00:00:00
 | 556 | 8 | 2021-01-27 00:00:00
 | 556 | 26 | 2021-01-27 00:00:00
 | 556 | 3 | 2021-01-27 00:00:00
 | 556 | 12 | 2021-01-27 00:00:00
 | 556 | 15 | 2021-01-27 00:00:00
 | 556 | 1 | 2021-01-27 00:00:00
 | 556 | 10 | 2021-01-28 00:00:00
 | 556 | 8 | 2021-01-29 00:00:00
 | 556 | 23 | 2021-01-28 00:00:00
 | 556 | 10 | 2021-01-28 00:00:00
 | 556 | 20 | 2021-01-28 00:00:00
 | 556 | 11 | 2021-01-28 00:00:00
 | 556 | 6 | 2021-01-28 00:00:00
 | 556 | 5 | 2021-01-28 00:00:00
 | 556 | 45 | 2021-01-28 00:00:00
 | 556 | 9 | 2021-01-28 00:00:00
 | 556 | 12 | 2021-01-28 00:00:00
 | 556 | 5 | 2021-01-29 00:00:00
 | 556 | 12 | 2021-01-28 00:00:00
 | 556 | 32 | 2021-01-28 00:00:00
 | 556 | 26 | 2021-01-28 00:00:00
 | 556 | 85 | 2021-01-28 00:00:00
 | 556 | 11 | 2021-01-28 00:00:00
 | 556 | 18 | 2021-01-29 00:00:00
 | 556 | 3 | 2021-01-30 00:00:00
 | 556 | 36 | 2021-01-30 00:00:00
 | 556 | 13 | 2021-01-29 00:00:00
 | 556 | 1 | 2021-01-29 00:00:00
 | 556 | 10 | 2021-01-29 00:00:00
 | 556 | 29 | 2021-01-30 00:00:00
 | 556 | 10 | 2021-01-30 00:00:00
 | 556 | 40 | 2021-01-30 00:00:00
 | 556 | 43 | 2021-01-30 00:00:00