SUMIFS with Multiple Criteria

Hi Everyone,

I wanted to sum up the payments for each LOC/Sys (which I created a helper). If the payment is on or before 12/31/23 with payment code of 24ARC. I also need formula for payments received after 12/31/23 and on 2/1/24, same goes after 2/1/24.

I have been trying to Google the SUMIFS formula that I might be able to incorporate into what I wanted to accomplish.

Please see the attached spreadsheet which contains 3 sheets. Payments are under the Checks and ACH tabs, and I want to sum the payments in 24INV tab.

Any help is greatly appreciated.

Try

in D2

Formula:

Please Login or Register  to view this content.

But all zero has there no data after 31 Dec 2023 (not there yet!)

similar in E and F

Does not use helper columns

Try

Formula:

Please Login or Register  to view this content.