julievandermeulen
Board Regular
- Joined
- Jan 25, 2020
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
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?
1drv.ms
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?
