how do i weight a series of rankings in excel?
 

I am trying to weight a series of performance indicators which have been
created as rankings - sales / profit / etc.. i can rank on perfrmance easily
but i want to weight those rankings... for instance sales is worth 60% and
profit is worth 40% of total score/rank.. any ideas?!

how do i weight a series of rankings in excel?
 

Let's say your sales score is 40 (cell a2), with a weighting of 60% (cell
b2) and profit score is 80 )cell a3) with a weighting of 40% (cell b3).

The normal math operation would be to multiple each percentage weighting by
the score and add up, so the XL formula would be:
=SUMPRODUCT(A2:A3,B2:B3)

--
Best Regards,

Luke M
"oliversdaddy" wrote in message
...
I am trying to weight a series of performance indicators which have been
created as rankings - sales / profit / etc.. i can rank on perfrmance
easily
but i want to weight those rankings... for instance sales is worth 60% and
profit is worth 40% of total score/rank.. any ideas?!