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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!