Need help with =SUMIF in summary report

Need help with =SUMIF in summary report

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])


Best Answers

  • Accepted Answer

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

Answers

Sign In or Register to comment.