Spreadsheet: 868303d1715023385-trying-to-calculate-ytd-total-comparison-using-sumifs-sample-data-sumifs-question
Sheet: Sheet1

ID | Fund | Service | Service Date | Month | Year | FY Month | Fiscal Year | Agency | Units | Total(USD)
453958 | Agency Funds General | Food Pantry/Groceries | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 50 |  | Location | Salvation Army Blue Valley Corps
213773 | Agency Funds General | Backpack/Book Bag | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 2 | 60 |  | Month | 12
191541 | KCMO Water Services Fund | Utility - Water | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 467.91 |  | FY Month | 3
191541 | Agency Funds General | Utility - Water | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 150
191541 | Agency Funds General | Interview Session | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 0
607634 | Agency Funds General | Utility - Water | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 593.05
607634 | Agency Funds General | Interview Session | 2021-10-04 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 0
358539 | Agency Funds General | Interview Session | 2021-10-05 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 0 |  |  | Monthly Comparision by Fiscal Year
358539 | Dollar Aide Credits | Utility - Electric | 2021-10-05 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 171.33
358539 | Agency Funds General | Utility - Electric | 2021-10-05 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 406.06 |  | FY22
358539 | Agency Funds General | Rent/Utilities | 2021-10-05 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 259 |  | FY23
277203 | KCMO Water Services Fund | Utility - Water | 2021-10-06 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 271.15 |  | FY24
277203 | Dollar Aide | Utility - Electric | 2021-10-06 00:00:00 |  |  | 1 | FY22 | Salvation Army Blue Valley Corps | 1 | 461.59
277203 | 2021 Metro Fund | Housing - Rent | 2021-11-06 00:00:00 |  |  | 2 | FY22 | Salvation Army Blue Valley Corps | 1 | 750
277203 | Agency Funds General | Rent/Utilities | 2021-11-06 00:00:00 |  |  | 2 | FY22 | Salvation Army Blue Valley Corps | 1 | 300 |  |  | [NAME] by Fiscal Year
277203 | Agency Funds General | Interview Session | 2021-11-06 00:00:00 |  |  | 2 | FY22 | Salvation Army Blue Valley Corps | 1 | 0
705451 | 2021 Metro Fund | Housing - Rent | 2021-12-06 00:00:00 |  |  | 3 | FY22 | Salvation Army Blue Valley Corps | 1 | 500 |  | FY22
705451 | Agency Funds General | Interview Session | 2021-12-06 00:00:00 |  |  | 3 | FY22 | Salvation Army Blue Valley Corps | 1 | 0 |  | FY23
705451 | Agency Funds General | Rent/Utilities | 2021-12-06 00:00:00 |  |  | 3 | FY22 | Salvation Army Blue Valley Corps | 1 | 300 |  | FY24
619716 | KCMO Water Services Fund | Utility - Water | 2021-12-06 00:00:00 |  |  | 3 | FY22 | Salvation Army Blue Valley Corps | 1 | 500
619716 | Agency Funds General | Interview Session | 2021-12-06 00:00:00 |  |  | 3 | FY22 | Salvation Army Blue Valley Corps | 1 | 0