Spreadsheet: 827299d1682594392-sumifs-not-working-on-google-sheets-davids-customer-tracker
Sheet: Tracker

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 | Customer Name |  | Project |  | Customer Number |  | Notes | Probability | Product | Number | Fee | MRR | DGs | Re/new | [NAME] | Contract | Subscription
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signed Date | Start Date | End Date | Months
 | Summary
 | Number of …
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How many of these = I imagine I will have the same problem with my [NAME]..
 | MRR
 | Digital Maintenance
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 144 | 150 |  |  | New |  |  | 2023-03-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 50 | 150 |  |  | New |  |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 180 | 175 |  |  | New |  |  | 2023-10-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 67 | 175 |  |  | New |  |  | 2023-03-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 45 | 175 |  |  | New |  |  | 2022-10-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 45 | 175 |  |  | New |  |  | 2022-10-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 364 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 364 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2023-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2023-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 178 | 100 |  |  | New |  |  | 2022-07-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 178 | 100 |  |  | New |  |  | 2022-07-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 50 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 50 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 213 | 100 |  |  | New |  |  | 2023-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 178 | 100 |  |  | New |  |  | 2022-07-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 364 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 50 | 100 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 1 | 7500 |  |  | New |  |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 1 | 7500 |  |  | New |  |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 28 | 175 |  |  | New |  |  | 2022-06-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 53 | 175 |  |  | New |  |  | 2022-08-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 45 | 175 |  |  | New |  |  | 2023-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 115 | 100 |  |  | New |  |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Licenses | 1 | 550 |  |  | New | Monthly |  | 2022-08-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Licenses | 1 | 550 |  |  | New | Monthly |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 115 | 100 |  |  | New |  |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 219 | 125 |  |  | New |  |  | 2023-05-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 266 | 125 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Licenses | 5 | 50 |  |  | New | Monthly |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 266 | 125 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Licenses | 5 | 50 |  |  | New | Monthly |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 219 | 125 |  |  | New |  |  | 2023-05-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 266 | 125 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Licenses | 5 | 50 |  |  | New | Monthly |  | 2022-01-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 219 | 125 |  |  | New |  |  | 2023-05-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 76 | 175 |  |  | New |  |  | 2023-03-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 50 | 175 |  |  | New |  |  | 2022-12-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 31 | 175 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 90 | 175 |  |  | New |  |  | 2022-10-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 113 | 175 |  |  | New |  |  | 2022-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 22 | 90 |  |  | New |  |  | 2024-04-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 23 | 90 |  |  | New |  |  | 2023-04-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 108 | 175 |  |  | New |  |  | 2023-03-01 00:00:00
[NAME] |  |  |  |  |  |  |  | 1 | Digital Maintenance | 88 | 175 |  |  | New |  |  | 2023-03-01 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | New