Sum Duration by Weeknumber

Andrea Westrich

I have the following columns that pertain to my formula:

Week Target - has a number (no formula that represents the target week of the year)

Duration (minutes) - this has how many minutes each task will take.

I want to create 3 sheet summary formulas that show a total of the hours of tasks set for for Last week, this week and next week.

For the current week, I've tried the following: =SUMIFS(WEEKNUMBER([Week Target]:[Week Target])@row = WEEKNUMBER(TODAY()), [Duration (minutes)]:[Duration (minutes)]) / 60)

What is wrong in this formula or is there a better way to do this?

Where do I add the -1 for last week's formula?

Mark Cronk

Hi @Andrea Westrich ,

Try:

=SUMIFS( [Duration (minutes)]:[Duration (minutes)]), [week target]:[week target], WEEKNUMBER(today(-7)) / 60)

Work?

Mark