Counting function

[Arnold R]

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.

 

[JE McGimpsey]

One way:

=COUNTIF(A:A,"n")

 

[Gary]

=COUNTIF(A1:A10,"N")

Assuming the data range is A1 to A10. You can change it as per the
requirement.

 

[Arnold R]

One way:

=COUNTIF(A:A,"n")


Thanks very much for your help.

 

[Arnold R]

=COUNTIF(A1:A10,"N")

Assuming the data range is A1 to A10. You can change it as per the
requirement.





Thanks very much for your help.