Spreadsheet: 880540d1728332632-sumifs-returning-0-when-it-shouldnt-summary_based_on_three_col
Sheet: Summary

IDNum | ID_Psn | ID_Note | Amount | Date |  | SumIFS
A1 | B1 | C1 | 426 | 2023-10-05 00:00:00
A1 | B1 | C2 | 65.4 | 05Oct2023, NA
A1 | B1 |  | 46.7 | 2023-10-05 00:00:00
A1 | B2 | C1 | 690.5999999999999 | 12Dec2023, NA
A1 | B2 | C2 | 76.80000000000001 | 12Dec2023, NA
A1 | B2 |  | 56.15000000000001 | 12Dec2023, NA
A1 | B3 | C1 | 627.5999999999999 | 05Mar2024, NA
A1 | B3 | C2 | 88.20000000000002 | 05Mar2024, NA
A1 | B3 |  | 56.15000000000001 | 05Mar2024, NA
A1 | B4 | C1 | 551.2 | 2023-09-06 00:00:00
A1 | B4 | C2 | 105 | 2023-09-06 00:00:00
A1 | B4 |  | 46.7 | 2023-09-06 00:00:00
A1 | B5 | C1 | 551.2 | 2023-09-05 00:00:00
A1 | B5 | C2 | 258 | 2023-09-05 00:00:00
A1 | B5 |  | 52.42 | 2023-09-05 00:00:00
A1 | B6 | C1 | 453.5999999999999 | 22Sep2023, 30Jan2024, NA
A1 | B6 | C2 | 130.8 | 22Sep2023, 30Jan2024, NA
A1 | B6 |  | 47.935 | 28Nov2023, NA
A2 | B1 | C1 | 426 | 2023-10-19 00:00:00
A2 | B1 | C2 | 65.4 | 19Oct2023, NA
A2 | B1 |  | 46.7 | 2023-10-19 00:00:00
A2 | B2 | C1 | 690.5999999999999 | 05Dec2023, NA
A2 | B2 | C2 | 76.80000000000001 | 05Dec2023, NA
A2 | B2 |  | 56.15000000000001 | 05Dec2023, NA
A2 | B3 | C1 | 627.5999999999999 | 12Mar2024, NA
A2 | B3 | C2 | 88.20000000000002 | 12Mar2024, NA
A2 | B3 |  | 56.15000000000001 | 12Mar2024, NA
A2 | B4 | C1 | 551.2 | 2023-09-15 00:00:00
A2 | B4 | C2 | 105 | 2023-09-15 00:00:00
A2 | B4 |  | 46.7 | 2023-09-15 00:00:00
A2 | B5 | C1 | 551.2 | 2023-09-15 00:00:00
A2 | B5 | C2 | 258 | 2023-09-15 00:00:00
A2 | B5 |  | 52.42 | 2023-09-15 00:00:00
A3 | B1 | C1 | 426 | 2023-10-12 00:00:00
A3 | B1 | C2 | 65.4 | 12Oct2023, NA
A3 | B1 |  | 46.7 | 2023-10-12 00:00:00
A3 | B2 | C1 | 690.5999999999999 | 12Dec2023, NA
A3 | B2 | C2 | 76.80000000000001 | 12Dec2023, NA
A3 | B2 |  | 56.15000000000001 | 12Dec2023, NA
A3 | B3 | C1 | 627.5999999999999 | 27Mar2024, NA
A3 | B3 | C2 | 88.20000000000002 | 27Mar2024, NA
A3 | B3 |  | 56.15000000000001 | 27Mar2024, NA
A3 | B4 | C1 | 551.2 | 2023-09-19 00:00:00
A3 | B4 | C2 | 116.4 | 19Sep2023, 20Sep2023
A3 | B4 |  | 46.7 | 2023-09-19 00:00:00
A3 | B5 | C1 | 551.2 | 2023-09-19 00:00:00
A3 | B5 | C2 | 258 | 2023-09-19 00:00:00
A3 | B5 |  | 52.42 | 2023-09-19 00:00:00
A4 | B1 | C1 | 426 | 2023-11-06 00:00:00
A4 | B1 | C2 | 65.4 | 06Nov2023, NA
A4 | B1 |  | 46.7 | 2023-11-06 00:00:00
A4 | B2 | C1 | 690.5999999999999 | 09Jan2024, NA
A4 | B2 | C2 | 76.80000000000001 | 09Jan2024, NA
A4 | B2 |  | 56.15000000000001 | 09Jan2024, NA
A4 | B3 | C1 | 627.5999999999999 | 25Mar2024, NA
A4 | B3 | C2 | 88.20000000000002 | 25Mar2024, NA
A4 | B3 |  | 56.15000000000001 | 25Mar2024, NA
A4 | B4 | C1 | 551.2 | 2023-10-05 00:00:00
A4 | B4 | C2 | 116.4 | 2023-10-05 00:00:00
A4 | B4 |  | 46.7 | 2023-10-05 00:00:00
A4 | B5 | C1 | 551.2 | 2023-10-05 00:00:00
A4 | B5 | C2 | 258 | 2023-10-05 00:00:00
A4 | B5 |  | 52.42 | 2023-10-05 00:00:00
A5 | B1 | C1 | 426 | 2023-11-07 00:00:00
A5 | B1 | C2 | 65.4 | 07Nov2023, NA
A5 | B1 |  | 46.7 | 2023-11-07 00:00:00
A5 | B2 | C1 | 690.5999999999999 | 09Jan2024, NA
A5 | B2 | C2 | 76.80000000000001 | 09Jan2024, NA
A5 | B2 |  | 56.15000000000001 | 09Jan2024, NA
A5 | B3 | C1 | 627.5999999999999 | 02Apr2024, NA
A5 | B3 | C2 | 88.20000000000002 | 02Apr2024, NA
A5 | B3 |  | 56.15000000000001 | 02Apr2024, NA
A5 | B4 | C1 | 551.2 | 2023-10-06 00:00:00
A5 | B4 | C2 | 105 | 2023-10-06 00:00:00
A5 | B4 |  | 46.7 | 2023-10-06 00:00:00
A5 | B5 | C1 | 551.2 | 2023-10-06 00:00:00
A5 | B5 | C2 | 258 | 2023-10-06 00:00:00
A5 | B5 |  | 90.905 | 2023-10-06 00:00:00
A6 | B1 | C1 | 627.5999999999999 | 15Dec2023, 21Dec2023
A6 | B1 | C2 | 88.20000000000002 | 15Dec2023, 21Dec2023, NA
A6 | B1 |  | 56.15000000000001 | 15Dec2023, 21Dec2023
A6 | B2 | C1 | 690.5999999999999 | 07Feb2024, NA
A6 | B2 | C2 | 76.80000000000001 | 07Feb2024, NA
A6 | B2 |  | 56.15000000000001 | 07Feb2024, NA
A6 | B4 | C1 | 752.8 | 11Nov2023, 23Nov2023
A6 | B4 | C2 | 139.2 | 11Nov2023, 23Nov2023
A6 | B4 |  | 56.15000000000001 | 11Nov2023, 23Nov2023
A6 | B5 | C1 | 551.2 | 2023-11-10 00:00:00
A6 | B5 | C2 | 258 | 2023-11-10 00:00:00
A6 | B5 |  | 52.42 | 2023-11-10 00:00:00
A7 | B1 | C1 | 426 | 2023-12-21 00:00:00
A7 | B1 | C2 | 65.4 | 21Dec2023, NA
A7 | B1 |  | 46.7 | 2023-12-21 00:00:00
A7 | B2 | C1 | 690.5999999999999 | 28Feb2024, NA
A7 | B2 | C2 | 76.80000000000001 | 28Feb2024, NA
A7 | B2 |  | 56.15000000000001 | 28Feb2024, NA
A7 | B4 | C1 | 752.8 | 24Nov2023, 27Nov2023
A7 | B4 | C2 | 127.8 | 24Nov2023, 27Nov2023
A7 | B4 |  | 56.15000000000001 | 24Nov2023, 27Nov2023
A7 | B5 | C1 | 551.2 | 2023-11-24 00:00:00
A7 | B5 | C2 | 258 | 2023-11-24 00:00:00
A7 | B5 |  | 52.42 | 2023-11-24 00:00:00
A8 | B1 | C1 | 426 | 2024-01-23 00:00:00
A8 | B1 | C2 | 65.4 | 23Jan2024, NA
A8 | B1 |  | 46.7 | 2024-01-23 00:00:00
A8 | B2 | C1 | 690.5999999999999 | 19Mar2024, NA
A8 | B2 | C2 | 76.80000000000001 | 19Mar2024, NA
A8 | B2 |  | 56.15000000000001 | 19Mar2024, NA
A8 | B4 | C1 | 752.8 | 19Dec2023, 22Dec2023
A8 | B4 | C2 | 127.8 | 19Dec2023, 22Dec2023
A8 | B4 |  | 56.15000000000001 | 19Dec2023, 22Dec2023
A8 | B5 | C1 | 551.2 | 2023-12-19 00:00:00
A8 | B5 | C2 | 258 | 2023-12-19 00:00:00
A8 | B5 |  | 90.905 | 18Dec2023, 19Dec2023
A8 | B6 | C1 | 453.5999999999999 | 29Jan2024, 09Feb2024, NA
A8 | B6 | C2 | 130.8 | 29Jan2024, 09Feb2024, NA
A8 | B6 |  | 79.26999999999998 | 28Jan2024, 29Jan2024, 09Feb2024, NA
A9 | B1 | C1 | 426 | 2024-01-30 00:00:00
A9 | B1 | C2 | 65.4 | 30Jan2024, NA
A9 | B1 |  | 46.7 | 2024-01-30 00:00:00
A9 | B2 | C1 | 690.5999999999999 | 02Apr2024, NA
A9 | B2 | C2 | 76.80000000000001 | 02Apr2024, NA
A9 | B2 |  | 56.15000000000001 | 02Apr2024, NA
A9 | B4 | C1 | 752.8 | 06Jan2024, 08Jan2024
A9 | B4 | C2 | 127.8 | 06Jan2024, 08Jan2024
A9 | B4 |  | 56.15000000000001 | 06Jan2024, 08Jan2024
A9 | B5 | C1 | 551.2 | 2024-01-06 00:00:00
A9 | B5 | C2 | 258 | 2024-01-06 00:00:00
A9 | B5 |  | 101.35 | 05Jan2024, 06Jan2024
A10 | B1 | C1 | 426 | 2024-02-20 00:00:00
A10 | B1 | C2 | 65.4 | 20Feb2024, NA
A10 | B1 |  | 46.7 | 2024-02-20 00:00:00
A10 | B2 | C1 | 690.5999999999999 | 23Apr2024, NA
A10 | B2 | C2 | 76.80000000000001 | 23Apr2024, NA
A10 | B2 |  | 56.15000000000001 | 23Apr2024, NA
A10 | B4 | C1 | 551.2 | 2024-01-16 00:00:00
A10 | B4 | C2 | 105 | 2024-01-16 00:00:00
A10 | B4 |  | 46.7 | 2024-01-16 00:00:00
A10 | B5 | C1 | 551.2 | 2024-01-16 00:00:00
A10 | B5 | C2 | 258 | 2024-01-16 00:00:00
A10 | B5 |  | 52.42 | 2024-01-16 00:00:00
A10 | B6 | C1 | 705.5999999999999 | 27Feb2024, 05Mar2024, 19Mar2024, 04Apr2024, NA
A10 | B6 | C2 | 238.8 | 27Feb2024, 05Mar2024, 19Mar2024, 04Apr2024, NA
A10 | B6 |  | 201.8749999999999 | 27Feb2024, 05Mar2024, 11Mar2024, 19Mar2024, 04Apr2024, NA
A11 | B1 | C1 | 426 | 2024-02-27 00:00:00
A11 | B1 | C2 | 65.4 | 27Feb2024, NA
A11 | B1 |  | 46.7 | 2024-02-27 00:00:00
A11 | B4 | C1 | 551.2 | 2024-01-24 00:00:00
A11 | B4 | C2 | 105 | 2024-01-24 00:00:00
A11 | B4 |  | 46.7 | 2024-01-24 00:00:00
A11 | B5 | C1 | 551.2 | 2024-01-24 00:00:00
A11 | B5 | C2 | 258 | 2024-01-24 00:00:00
A11 | B5 |  | 62.865 | 23Jan2024, 24Jan2024
A12 | B1 | C1 | 426 | 2024-03-05 00:00:00
A12 | B1 | C2 | 65.4 | 05Mar2024, NA
A12 | B1 |  | 46.7 | 2024-03-05 00:00:00
A12 | B4 | C1 | 551.2 | 2024-02-09 00:00:00
A12 | B4 | C2 | 105 | 2024-02-09 00:00:00
A12 | B4 |  | 46.7 | 2024-02-09 00:00:00
A12 | B5 | C1 | 551.2 | 2024-02-09 00:00:00
A12 | B5 | C2 | 258 | 2024-02-09 00:00:00
A12 | B5 |  | 62.865 | 08Feb2024, 09Feb2024
A13 | B1 | C1 | 426 | 2024-04-02 00:00:00
A13 | B1 | C2 | 65.4 | 02Apr2024, NA
A13 | B1 |  | 46.7 | 2024-04-02 00:00:00
A13 | B4 | C1 | 551.2 | 2024-03-07 00:00:00
A13 | B4 | C2 | 105 | 2024-03-07 00:00:00
A13 | B4 |  | 46.7 | 2024-03-07 00:00:00
A13 | B5 | C1 | 551.2 | 2024-03-07 00:00:00
A13 | B5 | C2 | 258 | 2024-03-07 00:00:00
A13 | B5 |  | 52.42 | 2024-03-07 00:00:00
A14 | B4 | C1 | 551.2 | 2024-03-12 00:00:00
A14 | B4 | C2 | 105 | 2024-03-12 00:00:00
A14 | B4 |  | 46.7 | 2024-03-12 00:00:00
A14 | B5 | C1 | 551.2 | 2024-03-13 00:00:00
A14 | B5 | C2 | 258 | 2024-03-13 00:00:00
A14 | B5 |  | 90.905 | 2024-03-13 00:00:00
A15 | B4 | C1 | 551.2 | 2024-03-29 00:00:00
A15 | B4 | C2 | 105 | 2024-03-29 00:00:00
A15 | B4 |  | 46.7 | 2024-03-29 00:00:00
A15 | B5 | C1 | 551.2 | 2024-03-29 00:00:00
A15 | B5 | C2 | 258 | 2024-03-29 00:00:00
A15 | B5 |  | 101.35 | 28Mar2024, 29Mar2024
A16 | B4 | C1 | 752.8 | 09Apr2024, 11Apr2024
A16 | B4 | C2 | 127.8 | 09Apr2024, 11Apr2024
A16 | B4 |  | 56.15000000000001 | 09Apr2024, 11Apr2024
A16 | B5 | C1 | 551.2 | 2024-04-09 00:00:00
A16 | B5 | C2 | 258 | 2024-04-09 00:00:00
A16 | B5 |  | 52.42 | 2024-04-09 00:00:00
A17 | B4 | C1 | 551.2 | 2024-04-12 00:00:00
A17 | B4 | C2 | 105 | 2024-04-12 00:00:00
A17 | B4 |  | 46.7 | 2024-04-12 00:00:00
A17 | B5 | C1 | 551.2 | 2024-04-11 00:00:00
A17 | B5 | C2 | 258 | 2024-04-11 00:00:00
A17 | B5 |  | 52.42 | 2024-04-11 00:00:00