I have a series of derived 'text' numbers to some formulas. Based on an answer I had received earlier, I made sure that these results became true numbers, and hence could be averaged, by using the edit/paste special feature and checking 'Add'.
So, now all zero values are counted and included in any averaging. This is fine as long as EVERY respondent to the questionnaire in question provided a response. Not always true. Given that I now have made the cell value = to a zero value, how do I EXCLUDE any cells that are empty (i.e. blank)in my averaging. By way of example, if all 10 respondents answered and there was a zero value, then that would be O.K. for the denominator on the average to be 10. But, if only 4 of 10 respondents answered and the other 6 cells are empty, I would want to average the received responses over only 4 and not 10 responses received. Is there a way I can do this?
So, now all zero values are counted and included in any averaging. This is fine as long as EVERY respondent to the questionnaire in question provided a response. Not always true. Given that I now have made the cell value = to a zero value, how do I EXCLUDE any cells that are empty (i.e. blank)in my averaging. By way of example, if all 10 respondents answered and there was a zero value, then that would be O.K. for the denominator on the average to be 10. But, if only 4 of 10 respondents answered and the other 6 cells are empty, I would want to average the received responses over only 4 and not 10 responses received. Is there a way I can do this?