SUMIFS formula with an error

System

This discussion was created from comments split from: SUMIFS to Calculate Values for a Specific Year/Date Range.

awitz

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

Paul Newcome

@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.

Carson Penticuff

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.

awitz

@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.

Carson Penticuff

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?

Paul Newcome

How exactly is the data in {Invoices Range 5} being populated?

awitz

@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.