Formula for total number of hours used in the last 28 days

Robert Harrison

I am struggling with coming up the formula for a metric sheet that I will use on my teams dashboard. I am looking to find out how many hours were used for a project in the last 28 days using the "Date worked", and "Total Hours worked" columns of my sheet. I have been trying to use the =SUMIF but can't seem to get it right.

Attached is a screenshot of the sheet I am trying to pull the info from.

David Tutwiler

The attachment didn't load, but you should be able to use SUMIF for this. It would look something like:

=SUMIF([Date worked]:[Date worked], >= TODAY(-28), [Total Hours worked]:[Total Hours worked])

Where the first range is the range being evaluated, the second parameter is checking to see if each cell meets that criteria, and the third parameter is the range you want to sum.

Robert Harrison

That worked perfectly. Thank you for the assistance.

David Tutwiler

No problem. Glad it worked.