Spreadsheet: 777434d1650378722-count-sum-of-column-if-cell-in-row-has-certain-value-cashflow-sample
Sheet: Sheet1

 |  |  | Proc Fee on KFI | L&G club wedge | Proc fee due | Date Proc fee paid | Completion Fee | Comp fee due | Date Completion fee paid | Case total expected | minus MAB 2.5% | Commission due | Comm paid  to [NAME] date | Status | Offered
 |  |  | 279.4 |  |  | 2021-05-07 00:00:00 | 395 |  | 2021-05-21 00:00:00 |  |  |  | 2021-06-18 00:00:00 | BANKED
 |  |  | 378 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 2400 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 299.2 |  |  | 2021-04-30 00:00:00 | 395 |  | 2021-06-03 00:00:00 |  |  |  | 2021-06-18 00:00:00 | BANKED
 |  |  | 570 |  |  | 2021-07-02 00:00:00 | 395 |  | 2021-09-27 00:00:00 |  |  |  | 2021-10-18 00:00:00 | BANKED
 |  |  | 652.5 |  |  | 2021-05-14 00:00:00 | 395 |  | 2021-04-30 00:00:00 |  |  |  | 2021-06-18 00:00:00 | BANKED
 |  |  | 367.2 |  |  | 2021-04-09 00:00:00 | 0 |  |  |  |  |  | 2021-05-18 00:00:00 | BANKED
 |  |  | 822.9 |  |  | 2021-04-02 00:00:00 | 395 |  | 2021-04-02 00:00:00 |  |  |  | 2021-04-18 00:00:00 | BANKED
 |  |  | 400 |  |  | 2021-10-29 00:00:00 | 395 |  | 2021-11-19 00:00:00 |  |  |  | 2021-12-18 00:00:00 | BANKED
 |  |  | 465 |  |  |  | 0 |  |  |  |  |  |  | NTU
 |  |  | 880 |  |  | 2021-07-02 00:00:00 | 395 |  | 2021-07-02 00:00:00 |  |  |  | 2021-07-18 00:00:00 | BANKED
 |  |  | 544 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 325 |  |  | 2021-06-18 00:00:00 | 0 |  |  |  |  |  | 2021-06-18 00:00:00 | BANKED
 |  |  | 275 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 275 |  |  |  | 0 |  |  |  |  |  |  | NTU
 |  |  | 700 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 820 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 2700 |  |  | 2021-10-15 00:00:00 | 395 |  | 2021-09-28 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 1476 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 901 |  |  | 2021-07-16 00:00:00 | 195 |  | 2021-10-21 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 774 |  |  | 2021-07-16 00:00:00 | 395 |  | 2021-08-06 00:00:00 |  |  |  | 2021-08-18 00:00:00 | BANKED
 |  |  | 1140 |  |  | 2021-07-02 00:00:00 | 295 |  | 2021-07-02 00:00:00 |  |  |  | 2021-07-18 00:00:00 | BANKED
 |  |  | 848.48 |  |  | 2021-07-09 00:00:00 | 0 |  |  |  |  |  | 2021-08-18 00:00:00 | BANKED
 |  |  | 1200 |  |  | 2021-08-27 00:00:00 | 395 |  | 2021-09-10 00:00:00 |  |  |  | 2021-10-18 00:00:00 | BANKED
 |  |  | 313 |  |  | 2021-08-06 00:00:00 | 395 |  | 2021-07-30 00:00:00 |  |  |  | 2021-08-18 00:00:00 | BANKED
 |  |  | 684 |  |  | 2021-10-29 00:00:00 | 395 |  | 2022-01-10 00:00:00 |  |  |  | 2021-01-18 00:00:00 | BANKED
 |  |  | 680 |  |  | 2021-08-20 00:00:00 | 395 |  | 2021-08-13 00:00:00 |  |  |  | 2021-09-18 00:00:00 | BANKED
 |  |  | 810 |  |  | 2021-08-20 00:00:00 | 395 |  | 2021-08-20 00:00:00 |  |  |  | 2021-09-18 00:00:00 | BANKED
 |  |  | 360 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 901 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 1425 |  |  | 2021-12-10 00:00:00 | 395 |  | 2021-12-10 00:00:00 |  |  |  | 2021-01-18 00:00:00 | BANKED
 |  |  | 1044 |  |  | 2021-07-23 00:00:00 | 395 |  | 2021-07-23 00:00:00 |  |  |  | 2021-08-18 00:00:00 | BANKED
 |  |  | 333 |  |  | 2021-08-13 00:00:00 | 0 |  |  |  |  |  | 2021-09-18 00:00:00 | BANKED
 |  |  | 1501.31 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 562.5 |  |  | 2021-08-20 00:00:00 | 395 |  | 2021-09-03 00:00:00 |  |  |  | 2021-09-18 00:00:00 | BANKED
 |  |  | 684 |  |  | 2021-10-08 00:00:00 | 395 |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 300 |  |  | 2021-10-15 00:00:00 | 395 |  | 2021-10-22 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 740 |  |  | 2021-10-15 00:00:00 | 395 |  | 2021-09-10 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 684 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 1184 |  |  |  | 995 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 720 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 1200 |  |  | 2021-10-29 00:00:00 | 395 |  | 2021-10-29 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 1010 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 1690.88 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 774 |  |  | 2021-11-19 00:00:00 | 395 |  | 2021-11-19 00:00:00 |  |  |  | 2021-12-18 00:00:00 | BANKED
 |  |  | 296 |  |  | 2022-03-11 00:00:00 | 395 |  | 2022-03-04 00:00:00 |  |  |  | 2022-04-18 00:00:00 | BANKED
 |  |  | 2300 |  |  | 2022-03-11 00:00:00 | 395 |  | 2022-03-11 00:00:00 |  |  |  | 2022-04-18 00:00:00 | BANKED
 |  |  | 1200 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1400 |  |  |  | 395 |  |  |  |  |  |  | NTU
 |  |  | 648 |  |  | 2021-11-05 00:00:00 | 395 |  | 2021-11-05 00:00:00 |  |  |  | 2021-11-18 00:00:00 | BANKED
 |  |  | 380 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1308.75 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1008 |  |  | 2022-01-14 00:00:00 | 395 |  | 2022-01-28 00:00:00 |  |  |  | 2022-02-18 00:00:00 | BANKED
 |  |  | 1036 |  |  | 2022-02-04 00:00:00 | 395 |  | 2022-01-28 00:00:00 |  |  |  | 2022-02-18 00:00:00 | BANKED
 |  |  | 2062.5 |  |  |  | 0 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 2498 |  |  | 2022-02-04 00:00:00 | 395 |  | 2022-02-04 00:00:00 |  |  |  | 2022-02-18 00:00:00 | BANKED
 |  |  | 800 |  |  |  | 695 |  |  |  |  |  |  | NTU
 |  |  | 1785 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1984 |  |  | 2022-02-18 00:00:00 | 395 |  | 2022-03-11 00:00:00 |  |  |  | 2022-04-18 00:00:00 | BANKED
 |  |  | 595 |  |  | 2022-01-14 00:00:00 | 395 |  | 2022-01-07 00:00:00 |  |  |  | 2022-02-18 00:00:00 | BANKED
 |  |  | 832 |  |  | 2022-01-14 00:00:00 | 395 |  | 2022-01-14 00:00:00 |  |  |  | 2022-02-18 00:00:00 | BANKED
 |  |  | 1411 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 792 |  |  | 2022-02-25 00:00:00 | 0 |  |  |  |  |  | 2022-03-18 00:00:00 | BANKED
 |  |  | 1530 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 2700 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 900 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 751.14 |  |  | 2021-12-10 00:00:00 | 0 |  |  |  |  |  | 2021-01-18 00:00:00 | BANKED
 |  |  | 442 |  |  |  | 0 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 504 |  |  | 2022-04-08 00:00:00 | 395 |  | 2022-04-08 00:00:00 |  |  |  |  | COMPLETED
 |  |  | 1750 |  |  |  | 0 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 2212 |  |  | 2022-04-08 00:00:00 | 395 |  |  |  |  |  |  | COMPLETED
 |  |  | 400 |  |  |  | 0 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 123.82 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1380 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 505 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 825 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1008 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1960 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1174.75 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 700 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1816 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1350 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 400 |  |  |  | 695 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 556.88 |  |  |  | 295 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1274.98 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1303.2 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 880 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 951.2 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 580 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1062 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1200 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 900 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 1904 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 937.5 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 450 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1680 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | NO
 |  |  | 588 |  |  |  | 395 |  |  |  |  |  |  | ACTIVE | YES
 |  |  | 1029.6 |  |  |  | 695 |  |  |  |  |  |  | ACTIVE | NO