Hi People.

A simple quality evaluation form with 13 questions.

Upon scoring Agents, there will be either 10, 11, 12 or 13 questions to be marked on. This means the calculation I use to provide averages as a percentage is off.

Problem cell....

CELL D43 = FORMULA = "SUM(D43/130)"

So in summary I need a way to change the calculation from =SUM(D43/130) to

=SUM(D43/120)

=SUM(D43/110)

=SUM(D43/100) depending on whether cells D7, D25 and D28 have a selection of "N/A".

I feel I need something like below but am unsure....

IF only CELL D7 = "N/A" then =SUM(D43/120)

IF only CELL D25 = "N/A" then =SUM(D43/120)

IF only CELL D28 = "N/A" then =SUM(D43/120)

IF 2 cells = "N/A" then =SUM(D43/110)

IF 3 cells = "N/A" then =SUM(D43/100)

Forgive my ignorance, Im learning.

Cheers.

Paul.