I have a table and I want to count the number of times a string appears on a column. I used
COUNTIF to do this, but I want to exclude in the count those cells with strings ending in any number.
I tried using this formula but the criteria is unrecognized as it always erroneously gives a value of 0:
The screenshot below shows I want to count how many times
Area 25 appears on column
San Jose Area 25 (since it contains the substring
San Jose Area 252 and
Area 251 (since these strings end in numbers AFTER the string
Area 25), and NOT
Area 25-A either (since
Area 25 is connected with another substring
So the result I want to see in Cell D3 is 4, which are:
Area 25 (cells A3 and A11),
Area 25 Zone B (cell A4), and
San Jose Area 25 (cell A8).