Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Count | New Users to Excel | |||
Count on cell for each time it is changed | Excel Discussion (Misc queries) | |||
I need to keep a count of the times a cell is changed | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |