DoktorPhill
New Member
- Joined
- Sep 23, 2020
- Messages
- 4
- Office Version
- 365
- 2010
- 2007
- Platform
- Windows
This is an hourly results table which can be extended quite far to the right, I want to add the values which correspond to all instances of each code (A,B,C etc), so in the table below "A" would be 1050 (100+100+200+250+100+300).
The codes are listed in a table elsewhere and the total will be next to them.
Currently I'm achieving this by using SUMIF($E$7:$E$16, $B41,$C$7:$C$16)+SUMIF($H$7:$H$16, $B41,$F$7:F$16)+SUMIF.... 24 times.. (B41 is the cell containing "A") but that seems inefficient
Is there a way to say, combine the whole table into one range and find the values at RC[-2] of each "A" and sum them?
The codes are listed in a table elsewhere and the total will be next to them.
Currently I'm achieving this by using SUMIF($E$7:$E$16, $B41,$C$7:$C$16)+SUMIF($H$7:$H$16, $B41,$F$7:F$16)+SUMIF.... 24 times.. (B41 is the cell containing "A") but that seems inefficient
Is there a way to say, combine the whole table into one range and find the values at RC[-2] of each "A" and sum them?