Creating a SUM when choosing a option from a Drop Down List

Hello,

I am a online seller and require my speadsheet to calculate a SUM once a option has been chosen from a drop down list.

For example I have 4 options in Cell D2:

Power Tools
Home & Garden
Vehicle Parts & Accessories
Business Office & Industrial

Once one of these have been selected I require a SUM to be created in Cell G2. I have added the sums for each different category below:

Power Tools - =SUM(J2*0.04348)
Home & Garden - =SUM(J2*0.0957)
Vehicle Parts & Accessories - =SUM(J2*0.06957)
Business Office & Industrial - =SUM(J2*0.0957)

Is there any way to do this?

Thank you in advance

Luke

Create a tab (sheet1) with each of these formula as column A Options "Power Tools etc." and Column B Formula itself.

Then on cell G2 type this.

=VLOOKUP(D2,Sheet20!A:B,2,FALSE)

Thank you guys, all sorted now. Saved me from pulling my hair out.

I had got =SUM as this is what I was using previously. This is why I was going around in circles trying to get this to work.

Anyhow thank you very much for your help. It's much appreciated.

Regards
Luke