I need help creating a score sheet with weighted values. Help Plea

E

Erin

I am trying to creat a simple worksheet with 7 columns to score employees in
a performance review. Each column has to be scored on a 1-5 point range,
while each column makes up a different percentage of the total score. (First
column making 10% of the final score, second colum is 25%, third 20% etc).
Any help would be greatly appreciated!
 
L

Luke M

If you want a complete formula, don't use "etc." when your percentage pattern
is not clear.

however, you could use SUMPRODUCT. Let's say your scores (1-5) are in range
A2:E2, and your percentage rankings are listed in range A1:E1

=SUMPRODUCT(A2:E2,$A$1:$E$1)
 

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

Calculate Weighted Value 3
How do I match values in a sub set after a sort? 1
Trouble with a Formula I need help with??? 7
with weekly score sheet how do I column a weekly progressive aver. 2
Need help to create a macro 3
Finding totals withing a seven day period 9
Help with creating query or creating report 0
I have a feeling the order of my formula is out of order....HELP! 3

Top