Spreadsheet: 765382d1643298090-counting-multiple-values-with-a-criteria-sampleworkbookcriteria
Sheet: Sheet1

 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
monthly amount reference | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | monthly amount | Formula 1 | Formula 2 | Desired result
5749 | 0 | 0 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 | 5749 |  |  | 0
5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 8523 | 8523 | 8523 | 8523 | 8523 | 8523 |  |  | 1
9267 | 9267 | 9267 | 9267 | 9267 | 7414 | 7414 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 9267 | 14205 | 14205 | 14205 | 14205 | 14205 | 14205 |  |  | 1
8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 | 8600 |  |  | 0
25000 | 25000 | 25000 | 25000 | 20000 | 20000 | 25000 | 25000 | 25000 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 | 6250 |  |  | 0
7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 | 7174 |  |  | 0
6176 | 6176 | 6176 | 6176 | 4941 | 4941 | 6176 | 6176 | 6176 | 6176 | 6176 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 |  |  | 0
7990 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7990 | 7990 | 7990 | 7990 | 7990 |  |  | 0
6176 | 6176 | 6176 | 6176 | 4941 | 4941 | 6176 | 6176 | 6176 | 6176 | 6176 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 |  |  | 0
5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 5463 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 |  |  | 0
588 | 588 | 588 | 588 | 588 | 588 | 3919 | 3919 | 3919 | 3919 | 3920 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 |  |  | 3
4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 | 4323 |  |  | 0
5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 5036 | 14305 | 14305 |  |  | 1
6812 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6812 | 6812 | 6812 | 6812 | 6812 | 6812 |  |  | 0
3219 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3219 | 3219 | 3219 | 3219 | 3219 | 3219 |  |  | 0
12164 | 12164 | 12164 | 12164 | 9731 | 9731 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 | 12164 |  |  | 0
8759 | 8759 | 8759 | 8759 | 7007 | 7007 | 8759 | 8759 | 8759 | 8759 | 8759 | 8800 | 8800 | 8800 | 8800 | 8800 | 8800 | 8800 | 10560 | 10560 | 10560 | 10560 | 10560 | 10560 | 10560 |  |  | 2