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

 | Store | Units | Date
 | 555 | 6 | 5561-02-16 00:00:00
 | 555 | 4 | 30/02/21
 | 555 | 20 | 30/02/21
 | 555 | 35 | 30/02/21
 | 555 | 176 | 30/02/21
 | 555 | 80 | 30/02/21
 | 555 | 77 | 30/02/21
 | 555 | 54 | 30/02/21
 | 555 | 56 | 30/02/21
 | 555 | 94 | 30/02/21
 | 555 | 4 | 5561-02-06 00:00:00
 | 555 | 8 | 5561-02-08 00:00:00
 | 555 | 6 | 5561-02-26 00:00:00
 | 555 | 14 | 5561-02-22 00:00:00
 | 555 | 2 | 29/02/21
 | 555 | 59 | 5561-02-27 00:00:00
 | 555 | 2 | 5561-02-28 00:00:00
 | 555 | 2 | 29/02/21
 | 555 | 2 | 29/02/21
 | 555 | 26 | 29/02/21
 | 555 | 3 | 29/02/21
 | 555 | 6 | 29/02/21
 | 555 | 2 | 5561-02-28 00:00:00
 | 555 | 39 | 30/02/21
 | 555 | 6 | 29/02/21
 | 555 | 12 | 5561-02-28 00:00:00
 | 555 | 12 | 30/02/21
 | 555 | 8 | 29/02/21
 | 555 | 12 | 29/02/21
 | 555 | 8 | 29/02/21
 | 555 | 15 | 29/02/21
 | 555 | 5 | 30/02/21
 | 555 | 3 | 29/02/21
 | 555 | 3 | 29/02/21
 | 555 | 8 | 29/02/21
 | 555 | 2 | 29/02/21
 | 555 | 34 | 30/02/21
 | 555 | 13 | 30/02/21
 | 555 | 18 | 29/02/21
 | 555 | 5 | 29/02/21
 | 555 | 14 | 29/02/21
 | 555 | 6 | 30/02/21
 | 555 | 5 | 30/02/21
 | 555 | 1 | 30/02/21
 | 555 | 9 | 30/02/21
 | 555 | 7 | 30/02/21
 | 555 | 7 | 30/02/21
 | 555 | 10 | 30/02/21
 | 555 | 8 | 30/02/21
 | 555 | 5 | 30/02/21
 | 555 | 4 | 30/02/21
 | 555 | 4 | 30/02/21
 | 555 | 4 | 30/02/21
 | 555 | 7 | 30/02/21
 | 555 | 11 | 30/02/21
 | 555 | 1 | 30/02/21
 | 555 | 18 | 30/02/21
 | 555 | 5 | 30/02/21
 | 555 | 11 | 30/02/21
 | 555 | 3 | 30/02/21
 | 555 | 18 | 30/02/21
 | 555 | 9 | 30/02/21
 | 555 | 7 | 30/02/21
 | 555 | 6 | 30/02/21
 | 555 | 108 | 30/02/21
 | 555 | 36 | 30/02/21
 | 555 | 4 | 30/02/21
 | 556 | 55 | 5561-02-21 00:00:00
 | 556 | 69 | 5561-02-23 00:00:00
 | 556 | 25 | 30/02/21
 | 556 | 41 | 30/02/21
 | 556 | 26 | 30/02/21
 | 556 | 4 | 30/02/21
 | 556 | 8 | 30/02/21
 | 556 | 60 | 30/02/21
 | 556 | 48 | 30/02/21
 | 556 | 33 | 30/02/21
 | 556 | 34 | 30/02/21
 | 556 | 74 | 30/02/21
 | 556 | 89 | 5561-02-21 00:00:00
 | 556 | 24 | 30/02/21
 | 556 | 51 | 30/02/21
 | 556 | 98 | 30/02/21
 | 556 | 138 | 30/02/21
 | 556 | 69 | 30/02/21
 | 556 | 20 | 30/02/21
 | 556 | 69 | 30/02/21
 | 556 | 60 | 30/02/21
 | 556 | 107 | 30/02/21
 | 556 | 114 | 30/02/21
 | 556 | 80 | 30/02/21
 | 556 | 13 | 5561-02-20 00:00:00
 | 556 | 34 | 5561-02-26 00:00:00
 | 556 | 4 | 5561-02-23 00:00:00
 | 556 | 7 | 5561-02-23 00:00:00
 | 556 | 12 | 5561-02-23 00:00:00
 | 556 | 6 | 5561-02-23 00:00:00
 | 556 | 8 | 5561-02-27 00:00:00
 | 556 | 6 | 29/02/21
 | 556 | 1 | 5561-02-27 00:00:00
 | 556 | 1 | 5561-02-28 00:00:00
 | 556 | 3 | 5561-02-27 00:00:00
 | 556 | 35 | 5561-02-27 00:00:00
 | 556 | 10 | 5561-02-27 00:00:00
 | 556 | 13 | 29/02/21
 | 556 | 92 | 5561-02-27 00:00:00
 | 556 | 15 | 5561-02-27 00:00:00
 | 556 | 19 | 29/02/21
 | 556 | 6 | 29/02/21
 | 556 | 4 | 29/02/21
 | 556 | 10 | 29/02/21
 | 556 | 5 | 29/02/21
 | 556 | 2 | 29/02/21
 | 556 | 76 | 29/02/21
 | 556 | 39 | 29/02/21
 | 556 | 22 | 5561-02-28 00:00:00
 | 556 | 9 | 5561-02-28 00:00:00
 | 556 | 29 | 5561-02-28 00:00:00
 | 556 | 9 | 5561-02-28 00:00:00
 | 556 | 12 | 5561-02-28 00:00:00
 | 556 | 19 | 30/02/21
 | 556 | 3 | 30/02/21
 | 556 | 52 | 29/02/21
 | 556 | 14 | 30/02/21
 | 556 | 8 | 29/02/21
 | 556 | 4 | 30/02/21
 | 556 | 8 | 29/02/21
 | 556 | 7 | 29/02/21
 | 556 | 1 | 29/02/21
 | 556 | 2 | 30/02/21
 | 556 | 10 | 30/02/21
 | 556 | 35 | 29/02/21
 | 556 | 22 | 30/02/21
 | 556 | 24 | 30/02/21
 | 556 | 22 | 30/02/21
 | 556 | 6 | 30/02/21
 | 556 | 2 | 29/02/21
 | 556 | 4 | 30/02/21
 | 556 | 3 | 29/02/21
 | 556 | 30 | 29/02/21
 | 556 | 16 | 29/02/21
 | 556 | 17 | 29/02/21
 | 556 | 10 | 30/02/21
 | 556 | 10 | 30/02/21
 | 556 | 8 | 30/02/21
 | 556 | 36 | 30/02/21
 | 556 | 6 | 30/02/21
 | 556 | 15 | 30/02/21
 | 556 | 1 | 30/02/21
 | 556 | 46 | 30/02/21
 | 556 | 3 | 5561-02-28 00:00:00
 | 556 | 1 | 5561-02-28 00:00:00