I have been scratching my head for hours trying to figure out the prope
macro/formula to use in order to do division on a sliding scale. Here'
what I need to do:

I am creating a performance evaluation spreadsheet where users will b
able to rate coworkers on their performance. There are 35 items that
person is rate on, so there are 35 rows. People are rated on a scal
from 1-8, so a perfect score would be 280 (35*8). The total score the
(280) would be divided by 35 for their final score. However, not all 3
items apply to everyone depending on their job position. For som
coworkers, 12 of the 35 items will apply to them, so I will need t
divide their score by 12, not 35. I know I can do a formula do divid
the score by 35 (for example: =SUM(B9/35), but I need a macro/formul
that will automatically divide the score by the number of applicabl
items (34, 33, 32, etc...). Is this possible? If anyone knows of
formula or macro, please tell me. I have been stumped by this proble
for hours.

Thanks for your help in this matter

--
Message posted from http://www.ExcelForum.com

See m.p.worksheet.functions for replys.

Please don't post the same message in more than one newsgroup. It just
tends to fragment your answers, and potentially wastes the time of those
replying to questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm



In article ,
ultra_xcyter wrote:

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.

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/

.