VLOOKUP & sum over multiple sections

[julievandermeulen]

I have a worksheet that i would like a formula for. I'm having trouble figuring out the correct formula and maybe it won't even work.

In cells AA11:AA40 I would like the sum form H11:S38 depending on the text in B11:B38 & E11:E38. For example B11 has "Loops" and E11 has "Albion" so I want the sum of (H11:R11) to be entered in cell AA11. The sum of H13:R13 to be enter in column AA depending on Text in B13 & E13.

But is it possible to also have it sum from H57:R84 (up tp 30 pages) or would each page need to be calculated separately?

Bucket Punch Sheet.xlsx

1drv.ms

 

[julievandermeulen]

oh I didn't know I could do that. I will thank you!