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