Average function for letters
"ZWarren" wrote:
I am trying to compute the percentage of the whole
A4:A24 range where the "X"s will count as a yes
and the blank field will count as a no, adding up
all the X's (yes's) and counting them against the
blank fields (no's) to get an percentage of how
many X's there are compared to blanks
AVERAGE is the wrong function to use for this purpose. Try:
=COUNTIF(A4:A24,"X")/ROWS(A4:A24)
formatted as Percentage.
Of course, you could replace ROWS(A4:A24) with 21.
|