SUMIFS returns a $0 (s/b an amount) once there are Oct 2022 & 2023 entries in a date range

Chelsea Smitchger

Aloha,

I have a SUMIFS formula that works until I have Oct 2022 and Oct 2023 entries in the date range. Then Oct 2023 returns a $0 when it should return an amount. I have tried reversing the month and year in order in the formula and it still returns a $0, any help would be appreciated.

=SUMIFS(Price33:Price174, [Expected Closing Date]33:[Expected Closing Date]174, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2023))

Chelsea Smitchger

A COUNTIFS formula for the same range and month/year would also be helpful. Thanks

Paul Newcome

It looks like the formula you posted is looking for September 2023 and not October.

Chelsea Smitchger

Thank, I have figured out the issues.