# Thread: Count The Number Of Times A Character Is Present (2000)

1. ## Count The Number Of Times A Character Is Present (2000)

This should be an easy one, but this early I have gridlock of the brain: I want look up a column and count the number of times an Alpha character appears. For example, I have a column that contains, randomly, only "Y"s and "N"s. I want a function in, say, the last cell of a column to count the number of times the letter "N" appears in the column and enter that figure in that last cell.
Any takers?
Thanks in advance,
Jeff

2. ## Re: Count The Number Of Times A Character Is Present (2000)

You could use
=COUNTIF(A1:A6;"N")

3. ## Re: Count The Number Of Times A Character Is Present (2000)

Hi Jeff,

Try something like
Countif("a1:a50","N"), where a1 to a50 is the range containing the Ys and Ns.

4. ## Re: Count The Number Of Times A Character Is Present (2000)

Yep-works fine.
Thanks Fran.
Jeff

5. ## Re: Count The Number Of Times A Character Is Present (2000)

Thanks Mike-yes , it works fine.
Jeff

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•