Count # of A's in a Cell
 

Try something like this:
For text in A1
B1: =SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A","")))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JavyD" wrote:

May I add, I've been using Countif, but lets say the cell has a Text like so
- ART GOES TO CAMP, it would say theres only one A, theres actually 2.

"JavyD" wrote:

How do you do this, tried to figure out, and I can't I need to count the
number of A's in a cell, or any other letter that I define. Thanks.