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
|