Counting function

Guest · Nov 1, 2007

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 · Nov 1, 2007

One way:

=COUNTIF(A:A,"n")

Gary · Nov 1, 2007

=COUNTIF(A1:A10,"N")

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

Guest · Nov 18, 2007

JE McGimpsey said:
One way:

=COUNTIF(A:A,"n")

Thanks very much for your help.

Guest · Nov 18, 2007

Gary said:
=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.

Counting function

Guest

JE McGimpsey

Gary

Guest

Guest