One way:

=COUNTIF(A:A,"n")

In article ,
Arnold R wrote:

I have a column of data that contains either the letter n or the letter y.
How can I count the number of cells that contain the letter n? I would have
thought this would be done with the COUNTA function but I can't see how.
Thanks for any help.