Division on a sliding scale

[ultra_xcyter]

I have been scratching my head for hours trying to figure out the prope
formula to use in order to do division on a sliding scale. Here's wha
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 rated 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 formula tha
will automatically divide the score by the number of applicable item
(34, 33, 32, etc...). Is this possible? If anyone knows of a formula o
macro, please tell me. I have been stumped by this problem for hours.

Thanks for your help in this matter

 

[MAX258]

Try using the COUNT function...for example if you have the following


Question Score
1 5
2 5
3 5
4
5
6 5
7 5
8
9
10
Total 25
=count(b1:b10)*25
=125

Hope that helps,
Ma

 

[JE McGimpsey]

First, you don't need SUM(), =B9/35 works just as well with less
typing and fewer function calls.

If your non-applicable cells will be left blank (or with text), just use

=AVERAGE(C1:C35)

 

[Dave R.]

Well if your non-used rows do NOT contain numbers, just use

=AVERAGE(A1:A35)

to obtain the average score. Average will ignore text and blank, but will
not ignore 0's unless asked to.