Counting function
 

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.

Counting function
 

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.

Counting function
 

=COUNTIF(A1:A10,"N")

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


"Arnold R" wrote in message
...
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.

Counting function
 

"JE McGimpsey" wrote:

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.
Thanks very much for your help.

Counting function
 

"Gary" wrote:

=COUNTIF(A1:A10,"N")

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


"Arnold R" wrote in message
...
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.



Thanks very much for your help.