counta

[Guest]

okay,

Im fairly new to spread sheets. Self teaching.

I have a column, it will either be filled with Y or N
(for yes or no obviously).

I was looking for a way to find the percentage that are Y
and the percentage that are N. So far I havent been able
to figure it out.

Any suggestions?

 

[J.E. McGimpsey]

one way:

% Yes:

B1: =COUNTIF(A:A,"Y")/COUNTA(A:A)

format as %.

% No:

=1 - B1

format as %.

 

[Ken Wright]

=COUNTIF(A:A,"Y")/COUNTA(A:A)

=COUNTIF(A:A,"N")/COUNTA(A:A)

Both formatted as %. Obviously you could just use 1-'The other' to get the
second % as well.

 

[Chris Leonard]

use the countif function

EG:

A1 to A40 contains either Y or N

B1 = countif(A1:A40, "Y")
B2 = B1/40*100


HTH

Chris