Formula for total number of hours used in the last 28 days
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.
Help Article Resources
Check out the Formula Handbook template!