C
Chey
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
How can I count how many E's and how many A's
Thanks
Cheyenne
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))
=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))
=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))
C
Chey
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
When I tried to change A1 to A6:A275 it says value.
Thanks
Cheyenne
T
Toppers
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
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
C
Chey
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