Hi. I am trying to create a formula which would count all of the occurrences of a certain text within a cell, as well as within a cell range.
Ex:
.....A
1...aa
2...a
3...b
4...b
5...c
In this example, the character "a" occurs 3 times in column A. The formula =COUNTIF(A:A,"*a*") will result in 2 because it cannot count "a" more than one time per cell.
How can I, within column A, count "a" more than once per cell without specifying the cell (A1)?
Bookmarks