Excel lookup - Tank Volume Puzzle - Sum the volumes in tanks based on type when the list order changes

We have storage tanks that are tracked by two main types and one group of other types.
The order of the list changes as the tanks are moved around the district.
Using  vlookup on type 1 and 2 we can keep track of the high priority volumes.
How would I total the volumes in all other types into one cell ?Tank-Puzzle.xlsm
AMixMasterAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
I have made some changes to your worksheet to be able to use the formulas more efficiently. This formula has been used for the desired sum

=SUM(OFFSET($B$3,1,MATCH($A13,$C$3:$H$3,0),5))-B13-C13

Enter the formula in D13 and copy it down.
0
 
AMixMasterAuthor Commented:
Renaming the row headings in the output to match the column headings solved the problem of using an exclusive function!
Keeping it simple is the way to go!
I actually lookup the values in a remote sheet, it should work for a remote reference.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.