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