Average function for letters

Z

ZWarren

I am trying to compute a percentage for a range of A4:A24; the onl
values in the cells are either an "X" or it is left blank.

If possible, I am trying to compute the percentage of the whole A4:A2
range where the "X"s will count as a yes and the blank field will coun
as a no, adding up all the X's (yes's) and counting them against th
blank fields (no's) to get an percentage of how many X's there ar
compared to blanks

Can anyone help please, Ive searched tutorials but im not sure this i
possible

Thanks E
 
J

joeu2004

ZWarren said:
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.
 
S

Spencer101

ZWarren;1566668 said:
I am trying to compute a percentage for a range of A4:A24; the onl
values in the cells are either an "X" or it is left blank.

If possible, I am trying to compute the percentage of the whole A4:A2
range where the "X"s will count as a yes and the blank field will coun
as a no, adding up all the X's (yes's) and counting them against th
blank fields (no's) to get an percentage of how many X's there ar
compared to blanks

Can anyone help please, Ive searched tutorials but im not sure this i
possible

Thanks EB

Quick and dirty, but it works :)

=COUNTA(A4:A24)/SUM(COUNTA(A4:A24)+COUNTBLANK(A4:A24)

Format the cell as %
 
Z

ZWarren

Spencer101;1568500 said:
Quick and dirty, but it works :)

=COUNTA(A4:A24)/SUM(COUNTA(A4:A24)+COUNTBLANK(A4:A24)

Format the cell as %.

This worked, I appreciate it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top