I am trying to create a formula for weighted voting/scoring.

I have 5 scoring catagories.

I will call the catagories a, b, c, d, e.
Each catagory could recieve a score of 1 - 10.

Catagory A should account for 35% of the total score.
Catagory B should account for 35% of the total score.
Catagory C should account for 20% of the total score.
Catagories D, E should each account for 5% total score.

thanks for any help with this




--
Perry K