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