SUMIFS criteria for date range (Monthly) #INVALID OPERATION

UDP · 03/18/19

Hello everyone!

I'm trying to make a formula that sums this year sales by month. I have this formula but it returns #INVALID OPERATION, would you mind helping me fix it. much appreciated.

=SUMIFS([Valeur TTC]:[Valeur TTC], CO:CO = "UD", Date:Date, IFERROR(MONTH(@cell), 0) = 1, Date:Date, IFERROR(YEAR(@cell), 0) = 2019)

Andrée Starå · 03/18/19

Hi,

Try this.

=IFERROR(SUMIFS([Valeur TTC]:[Valeur TTC]; CO:CO; "UD"; Date:Date; MONTH(@cell) = 1; Date:Date; YEAR(@cell) = 2019); 0)

The same version but with the below changes for your and others convenience.

=IFERROR(SUMIFS([Valeur TTC]:[Valeur TTC], CO:CO, "UD", Date:Date, MONTH(@cell) = 1, Date:Date, YEAR(@cell) = 2019), 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

UDP · 03/18/19

Hi Andrée!

Thank you for you reply, the formula worked!

Would you mind explaining why my version didn't work, knowing that the other columns didn't have blank cells, that's why I put iferror only in the date column.

best

Ahmed

Paul Newcome · 03/21/19

Ahmed,

It was your first criteria range/criteria. You used CO:CO = "UD" when the proper format would be what you had used for the dates (and which Andree corrected) CO:CO, "UD"

Andrée Starå · 03/22/19

Excellent!

Happy to help!

I saw that Paul answered.

Let me know if I can help in any other way!

Have a fantastic weekend!

Best,

Andrée

SUMIFS criteria for date range (Monthly) #INVALID OPERATION

Comments

Help Article Resources

Categories