Google-sheets – Sum values by week using weeknumber

formulasgoogle sheets

I am trying to calculate the hours for each week (starting Monday).

What formula should I write to: retrieve the weekly sum of hours from another tab (based on week number)?

=sumif(C2:C, <your week number here>, D2:D)

The problem is that address returns a string, so you need to turn that string into a reference.

Try this:

=sumif(indirect(address(F2,G2,2)&":"&address(ROW(B2),COLUMN(B2))),B2,indirect(address(F2,H2,2)&":"&address(ROW(C2),COLUMN(C2))))

If you have multiple sums in the formula, you need multiple SUM commands, one for each sum. That is,

=F15*20+SUM(F16:F20)*25+SUM(F21:F23)*30

Have to add things up before multiplying them all by a common factor.