how do i weight a series of rankings in excel?

O

oliversdaddy

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?!
 
L

Luke M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I Combine Rankings for Multiple Categories? 1
How Do I Combine Rankings for Multiple Categories? 1
Excel Rankings function 8
how do i rank based on other rankings? 10
percentage weight 3
Erroneous Grand Total of calculated fields in pivot table 2
how do i use excel to calculate weight (as in stone and lbs)? 6
How do I calculate profit as a % of Sales price 3

Top