Count letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an E and an A in the cells but not both.
How can I count how many E's and how many A's
Thanks
Cheyenne
 
I don't understand where do i put my range. It is A6:A275.
When I tried to change A1 to A6:A275 it says value.
Thanks
Cheyenne
 
The formula counts the number of As OR Es in ONE cell. If you want to count
the number of As a or Es in a range of cells AND each cell has only ONE of
either letter:

=COUNTIF(A6:A275,"*A*")

Sorry if misunderstood your question.

HTH
 
Perfect thank you

Toppers said:
The formula counts the number of As OR Es in ONE cell. If you want to count
the number of As a or Es in a range of cells AND each cell has only ONE of
either letter:

=COUNTIF(A6:A275,"*A*")

Sorry if misunderstood your question.

HTH
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 functions in 1 2
Print 8
Counting number of items excluding duplicates. 1
If or lookup Statement 2
Last Number in Column 2
trim 4
COUNT IF - Conditional Formatting 2
Date Search 2

Back
Top