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.