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" 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 failureNext: text & formual problem combined