Help Please

[xxsalahxx]

I have 19 questions in a spreadsheet, and im trying to work out the overall mean by dividing the total number of questions answered, If any questions were answered as "Not Applicable" or were left blank i do not want to count them in the denominator, any ideas for the formula? thanking you in advance.

 

[VoG]

Try

=AVERAGE(A1:A19)

Excel will ignore text and blanks.

 

[Andrew Poulsom]

Try a formula like this as the divisor:

=SUM(COUNTIF(Range,{"Not Applicable",""}))