counta

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
one way:

% Yes:

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

format as %.

% No:

=1 - B1

format as %.
 
=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.
 
use the countif function

EG:

A1 to A40 contains either Y or N

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


HTH

Chris
 
Back
Top