Smartsheet SUMIFS returning a zero value but working correctly on Excel

Dee.M

I am trying to calculate the CO Value if the Date Created in the corresponding rows are Dec-2021.

My CO Value Column is formatted to "Currency" and my Date Created Column is formatted to "Date".

Formula used is as follows:

=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, ">=01-Dec-2021", [Date Created]2:[Date Created]52, "<=31-Dec-2021")

This is returning a €0.00 value.

I have replicated this in Excel and it is working correctly but will not return the correct value in Smartsheet.

Can you please offer a solution.

Sumifs Problem.PNG

Dee.M

Thank you Genevieve,

That has worked perfectly.

Genevieve P.

Hi @Dee.M

Your current formula is searching for the text of ">=01-Dec-2021" since you have quotes around this value. If you're looking for a date, you'll want to use the DATE function, try this:

=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, >= DATE(2021, 12, 1), [Date Created]2:[Date Created]52, <= DATE(2021, 12, 31))

Cheers,

Genevieve

Dee.M

Thank you Genevieve,

That has worked perfectly.

Genevieve P.

Wonderful! Thanks for letting me know, I'm glad I could help.