SUMIFS formula with an error

Answers
-
HELP: Please find my error in sumifs statement:
=SUMIFS({Invoices Range 5}, {Invoices Range 2}, IFERROR(YEAR(@cell), 0) = 2023, {Invoices Range 2}, IFERROR(MONTH(@cell), 0) = 6)
Just returns 0
-
@awitz Your syntax looks fine. I would start by double checking that each of your ranges are in fact pointing to the appropriate columns in the source sheet.
-
Your formula works fine for me. Double check that {Invoices Range 2} is correctly formatted as a date and that the cell you are placing this formula into is formatted as Text/Number.
-
@Carson Penticuff I double checked the formatting
@Paul Newcome I verified I am pointing the the correct columns
It still comes up as 0.
Thank you for trying to help.
-
Maybe try retyping the date into some of the source cells. It could be possible that the cell formatting is correct but something about the entry could have been off prior to that formatting?
-
How exactly is the data in {Invoices Range 5} being populated?
-
@Carson Penticuff @Paul Newcome Thank you both for suggestions. I figured it out. I added zeros to all lines which were blank & Realized that for the month of June I didn't have any amount due. Thank again for your prompt response & support.
Help Article Resources
Categories
Check out the Formula Handbook template!