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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help Please
- Thread starter xxsalahxx
- Start date
Similar threads
- Question
- Question
