Assumes names going down and questions across:
Question # 1 2 3 4 3Score
Sandy 8 5 8 5 6 6.4
=SUM(B2:G2)/COUNT(B2:G2)
Dan 5 8 5 6
Jil 1 5 8 5 6 5
Hope you can read this columns don't align very well.
-----Original Message-----
I have been scratching my head for hours trying to
figure out the proper
macro/formula to use in order to do division on a
sliding scale. Here's
what I need to do:
I am creating a performance evaluation spreadsheet where
users will be
able to rate coworkers on their performance. There are
35 items that a
person is rate on, so there are 35 rows. People are
rated on a scale
from 1-8, so a perfect score would be 280 (35*8). The
total score then
(280) would be divided by 35 for their final score.
However, not all 35
items apply to everyone depending on their job position.
For some
coworkers, 12 of the 35 items will apply to them, so I
will need to
divide their score by 12, not 35. I know I can do a
formula do divide
the score by 35 (for example: =SUM(B9/35), but I need a
macro/formula
that will automatically divide the score by the number
of applicable
items (34, 33, 32, etc...). Is this possible? If anyone
knows of a
formula or macro, please tell me. I have been stumped by
this problem
for hours.
Thanks for your help in this matter.
---
Message posted from http://www.ExcelForum.com/
.