sum of hours based on weeknumber

I have project hours and dates and this summary formula works well: =SUMIF(PressDate:PressDate, TODAY(), (PressHours:PressHours))

I also have a weeknumber formula on the sheet =weeknumber(PressDate@row) for the weeknumber of the press date and on the summary =WEEKNUMBER(TODAY()) to calculate the weeknumber based on today .

what i am trying to do is create a sumif formula that sums the PressHours based on today's week number.

example formula below which doesn't error but doesn't work either to sum all the presshours based on todays weeknumber which is 9.

=SUMIF(PressDate:PressDate, WEEKNUMBER(TODAY(), PressHours:PressHours))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!