View Single Post
 
Old 05-07-2019, 01:15 PM
will soar will soar is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Default Problem> do not include 999 in calculations

Good evening,

I must start by stating I'm not even a novice when it comes to working formulas in excel. I could really use some help, please.

I have attached a file that I am trying to get the MEAN/AVERAGE for the values in the rows. It is part of a questionnaire I use. Some of the questions have been reversed to maintain the interity of the survey. I have added value for a question that is outside the 1-4 response, 999. when I am calculation the averages I do not want to include the 999. I also have some blank cells which need to remain blank, indicating the question was not answered.

another thing I was hoping to see if possible to add to COUNT part at end of formula is that the average only is counted if the number of questions answered, or the number of 999 is greater than 50%.

I would really appreciate any direction and input you may have.

Thank you
Attached Files
File Type: xlsx 999calc.xlsx (9.2 KB, 7 views)
Reply With Quote