Spreadsheet: 792073d1660728574-countifs-multiple-criteria-and-date-has-to-be-15th-of-the-month-example
Sheet: Tables

 | 2022
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] and then Paste Values Before Updating for New Month
[NAME] |  | FY20 |  |  |  |  |  | FY21 |  |  |  |  |  |  |  |  |  |  |  | FY22
New Deal Tracker |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | Amortized | 656 | 663.2619926199262 | 674 | 685 | 691 | 642 | 646 | 653 | 651 | 647 | 647 | 632 | 630 | 620 | 616 | 614 | 612 | 597 | 585 | 581 | 565 | 575 | 610 | 593 | 591 | 598 | 595
 | Non-Amortized | 186 | 191 | 193 | 199 | 167 | 193 | 199 | 212 | 184 | 200 | 217 | 229 | 227 | 232 | 239 | 261 | 259 | 264 | 269 | 245 | 213 | 218 | 222 | 248 | 259 | 278 | 285
 | Hybrid | 54 | 55.74193548387097 | 68 | 71 | 76 | 73 | 80 | 78 | 86 | 81 | 82 | 79 | 92 | 99 | 103 | 112 | 114 | 124 | 128 | 126 | 122 | 127 | 133 | 130 | 130 | 132 | 134
Real Time Direct Discounts | Real Time Discount/Direct Discounting contracts |  |  |  | 36 | 40 | 42 | 42 | 50 | 55 | 57 | 60 | 60 | 63 | 63 | 63 | 65 | 65 | 65 | 67 | 69 | 72 | 73 | 75 | 76 | 68 | 68 | 68 | 68
 | Total Number of Active Contracts
VIK Report | Incentive Type | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | Amortized | 3452 | 3468 | 3489 | 3534 | 3536 | 3734 | 3775 | 3851.4 | 3866.2 | 3857.2 | 3846.6 | 3864 | 3893.4 | 3833.4 | 3954 | 3815.4 | 3825.8 | 3821.2 | 3789.6 | 3775.6 | 3748.2 | 4313 | 4345 | 4310 | 4465 | 4557 | 4570
 | Non-Amortized | 310 | 320 | 320 | 323 | 333 | 792 | 785 | 519 | 443.8 | 351 | 470.8 | 508 | 512 | 547.8 | 554.4 | 612.8 | 560 | 594.6 | 572.8 | 557.8 | 502.8 | 518 | 540 | 606 | 667 | 671 | 665
 | Hybrid | 101 | 110 | 122 | 124 | 135 | 143 | 160 | 174 | 188 | 202 | 202 | 211 | 258 | 277 | 313 | 332 | 358 | 395 | 431 | 428 | 417 | 468 | 475 | 487 | 504 | 495 | 499
 | VIK | 318 | 322 | 324 | 333 | 335 | 336 | 348 | 400 | 430 | 436 | 443 | 463 | 478 | 483 | 501 | 496 | 503 | 516 | 528 | 538 | 544 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 69 | 69 | 69 | 69 | 69 | 69 | 76 | 76 | 69 | 87 | 94 | 110 | 108 | 104 | 121 | 84 | 87 | 84 | 71 | 71 | 72 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Number of Incentives | 4250 | 4289 | 4324 | 4383 | 4408 | 5074 | 5144 | 5020.4 | 4997 | 4933.2 | 5056.4 | 5156 | 5249.4 | 5245.2 | 5443.4 | 5340.2 | 5333.8
 | Incentive Type | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | Amortized
 | Non-Amortized
 | Hybrid
Payments | Number of Payments Processed (Distinct & Not Including Waivers) |  |  |  |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep |  | req | 144
 | Number Processed FY22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 64 | 68 | 63 | 87 | 79 | 61 | 62 | 91 |  |  |  |  | waivers | 7 | needs to be indicated in tracker
 | Number Processed FY21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 67 | 62 | 53 | 90 | 88 | 56 | 62 | 73 | 95 | 184 | 175 |  | 137 poss payments
[NAME] | Requests Received FY22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78 | 80 | 86 | 93 | 110 | 99 | 91 | 104 | 124 | 137 |  |  |  | deferred | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | how many should be made
Payments - Cash Book | Payments Processed $m | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | $m Volume Processed |  |  |  |  |  |  | 151.6 | 64.3 | 116.7 | 102.6 | 100.4 | 159.8 | 128 | 85.6 | 110.6 | 42 | 232 | 52 | 91.4 | 97.15 | 114.499032613487 | 47.1122066910567 | 122.299846812332 | 90.8910492026557 | 135.693964151511 | 252.193948780248 | 142.986611198337
 | YTD 2021 Total
 | YTD 2022 Total
 | Payment - CB by Type | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | GMBS |  |  |  | 64 | 50 | 83 | 48 | 89 | 98 | 86 | 95 | 143 | 96 | 56 | 90 | 52 | 113 | 102 | 38 | 43 | 50 | 43 | 58 | 49 | 47 | 44 | 72 | 34
 | Manual |  |  |  | 20 | 24 | 40 | 28 | 20 | 37 | 12 | 30 | 19 | 37 | 23 | 23 | 31 | 54 | 50 | 20 | 15 | 12 | 13 | 17 | 15 | 8 | 15 | 4 | 5 |  |  |  | reclass
 | AP Interface |  |  |  |  |  |  |  |  | 1 | 15 | 6 | 10 | 5 | 11 | 11 | 12 | 17 | 23 | 2 | 6 | 6 | 7 | 12 | 15 | 6 | 3 | 15 | 16
 | Total Number of Payments
Live Deal Tracker | Deal Builds | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | New Contracts |  |  |  | 22 | 21 | 42 | 20 | 13 | 15 | 23 | 26 | 46 | 31 | 11 | 31 | 38 | 14 | 65
 | LOV's |  |  |  | 20 | 11 | 15 | 15 | 14 | 23 | 10 | 12 | 20 | 16 | 6 | 24 | 4 | 13 | 29
 | Total Number of Deal Builds
Live Deal Tracker | Build Status | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | Oct - FY22 | Nov - FY22 | Dec - FY22 | Jan - FY22 | Feb - FY22 | Mar - FY22 | Apr - FY22 | May - FY22 | June - FY22 | July - FY22 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00
 | Completed |  |  |  | 42 | 32 | 57 | 35 | 27 | 38 | 33 | 38 | 66 | 47 | 17 | 55 | 42 | 27 | 93
 | Outstanding (Cash) |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | count if its wip, new build cash and signed date is between 1/7/22 and 15/7/22
 | Outstanding (Cash) Signed Post 15th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | count if its wip, new build cash and signed date is between  15/7/22 and end of july
 | Outstanding (Amortised) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Outstanding (Amortised) Signed Post 15th
 | Total Outstanding |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Total Signed Post 15th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | Total Build Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this needs to be everything pre 15th in june
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this needs to be everything pre 15th in june
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outsanding cash and amort defined as WIP, SUBMITTED, PRE 15TH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | blanks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lock formulas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | embedd ppt