Division on a sliding scale

[ultra_xcyter]

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

 

[JE McGimpsey]

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

 

[David]

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.