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
Allen PrinceTraining DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Allen PrinceTraining DeveloperAuthor 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.