Count letters
 

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

Count letters
 

=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))

=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))


"Chey" wrote:

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

Count letters
 

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

"Toppers" wrote:


=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))

=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))


"Chey" wrote:

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

Count letters
 

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

"Chey" wrote:

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

"Toppers" wrote:


=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))

=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))


"Chey" wrote:

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

Count letters
 

Perfect thank you

"Toppers" wrote:

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

"Chey" wrote:

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

"Toppers" wrote:


=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))

=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))


"Chey" wrote:

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