Finding the sum/ average of non numerical values?

[rickv1957]

Hello,
I have a cell which contains non numerical values.
It will contain a Y (for yes) N(for no) or might be blank.
I need a formula to calculate # Y's, # N's and then be able to
create a chart to show the percentage of Y's and N's.
Thanks for any help,

Rick

 

[Frank Kabel]

Hi
use COUNTIF:
=COUNTIF($A$1:$A$9999,"Y")
count all 'Y' in column A

HTH
Frank

 

[grecian9]

Hi, it's quite easy. All you have to do is convert the text to a code
eg; 1 for Yes and 2 for No and then do the averaging and percentaging.
To do this you need to use an "If" function. The following should d
the trick. Use this formula in the column next to your data and the
copy and paste the results as values before doing the averaging.

=IF(A1="y",1,IF(A1="n",2,FALSE))


Hope it works for you.

Nic