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



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))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!