Tallying Letters

[John Wright OCC]

I have a column that has Y's and N's in it, I need to tally the number of Y's
in the column. Is there a function or some other option for doing this?

 

[Don Guillett]

look in the help index for COUNTIF or SUMIF

 

[Mike H]

Hi,

Maybe this:-

=COUNTIF(A1:A20,"y")

Suitably edited for "n"

Mike