Need help with =SUMIF in summary report

laura.buchanan

I'm trying to get a sum of time spent for week ending date 7/31/20. This formula gives me a total of zero. Any suggestions for what I'm doing wrong? I've tried the date with and without " ". Thanks!

=SUMIF([Week Ending Date]:[Week Ending Date], ="07/31/20", [Time Spent]:[Time Spent])

Stefan

Hi @laura.buchanan ,

in your formula you try to compare the text string "07/31/20" with a date and that does not work.

Try this:

=SUMIF([Week Ending Date]:[Week Ending Date], =DATE(2020, 7, 31), [Time spent]:[Time spent])

Hope this helps

Stefan

Genevieve P.

Hi @laura.buchanan

Since you're looking for a date value, you'll want to use the DATE function so that the formula can read your Column Type correctly!

Try this:

=SUMIF([Week Ending Date]:[Week Ending Date], DATE(2020, 7, 31), [Time Spent]:[Time Spent])

Cheers,

Genevieve

laura.buchanan

Thanks so much for the great feedback! Working now!! :-)

Stefan

Hi @laura.buchanan ,

in your formula you try to compare the text string "07/31/20" with a date and that does not work.

Try this:

=SUMIF([Week Ending Date]:[Week Ending Date], =DATE(2020, 7, 31), [Time spent]:[Time spent])

Hope this helps

Stefan

Genevieve P.

Hi @laura.buchanan

Since you're looking for a date value, you'll want to use the DATE function so that the formula can read your Column Type correctly!

Try this:

=SUMIF([Week Ending Date]:[Week Ending Date], DATE(2020, 7, 31), [Time Spent]:[Time Spent])

Cheers,

Genevieve

laura.buchanan

Thanks so much for the great feedback! Working now!! :-)

Stefan

Pleasure

greetings

Stefan