Spreadsheet: 859093d1707544066-maxifs-max-count-based-on-multliple-criteria-tracking-test-dj
Sheet: SUMMARY

 |  |  |  |  | START: | 2024-01-01 00:00:00
BANKS ISSUED | TOTAL COUNT | DAY | SWING | GRAVE | END: | 2024-02-28 00:00:00 |  |  |  |  |  |  |  | Your expected result
BANK #01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 0
BANK #03 |  | 1 | 3 | 0 |  |  |  |  |  |  |  |  |  | 1 | 3 | 0
BANK #04 |  | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0
BANK #02 (ISSUES) |  | 4 | 3 | 1 |  |  |  |  |  |  |  |  |  | 4 | 3 | 1
BANK #02 (RETURNS) |  | 1 | 3 | 4 |  |  |  |  |  |  |  |  |  | 0 | 3 | 4
DATE | SHIFT | EMPLOYEE | EMP # | TYPE | OUTLET | AMOUNT
 | DAY | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900 |  | 2 |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900 |  |  |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900 |  | 2 |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900 |  |  |  | 2
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900 |  | 2 |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900 |  | 1 |  | 0
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900 |  | 1 |  | 0
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  | 2 |  | 0
2024-01-02 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  | 1 |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000 |  | 3 |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000 |  | 4 |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000 |  | 3 |  | 0
2024-01-03 00:00:00 | GRAVE | 0 | 0 | ISSUE | BANK #02 | 15000 |  | 1 |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | RETURN | BANK #02 | 15000 |  | 1 |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000 |  | 2 |  | 0
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000 |  |  |  | 0
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000 |  | 4 |  | 0
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #03 | 687.5 |  | 1 |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5 |  |  |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5 |  | 2 |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #03 | 687.5 |  | 1 |  | 0
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5 |  |  |  | 0
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5 |  |  |  | 0
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5 |  | 3 |  | 0
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #04 | 687.5 |  | 1 |  | 0
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #04 | 687.5 |  | 1 |  | 0
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #04 | 687.5 |  | 1 |  | 0
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #04 | 687.5 |  | 1 |  | 0
 |  |  |  |  |  |  |  |  |  | #N/A