Prev: mail failure
Next: text & formual problem combined
From: oliversdaddy on 9 Mar 2010 08:21
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?!
From: Luke M on 9 Mar 2010 09:03
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" <oliversdaddy(a)discussions.microsoft.com> wrote in message
news:96CD7016-5AB2-494E-991F-E507314D87DF(a)microsoft.com...
>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?!


 | 
Pages: 1
Prev: mail failure
Next: text & formual problem combined