Calculate totals based on selected rows

[marcusjb]

If you can suggest a better way to do this please do.

I've attached a basic example of what i'm trying to accomplish.

I have a price sheet where column A is parts names and C:E are pricing depending on who the buyer is, (wholesale, retail, etc..)

I'd like to have a drop down where they select what type of buyer it is (in the example see G3) G4 should be a total of the parts they're purchasing based on what type of buyer they are. I'm thinking of using the B to put an X next to what they're purchasing to indicate what they're buying.

lastly if possible i'd like it to hide the columns of pricing that aren't being used, in this case C & D.

thank you in advance.