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:

```
=COUNTIF([Name],"*"&A3&NOT(ISNUMBER(VALUE(RIGHT("*")))))
```

EDIT:

The screenshot below shows I want to count how many times `Area 25`

appears on column `Name`

,

including `San Jose Area 25`

(since it contains the substring `Area 25`

)

but NOT `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 `-A`

:

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).

`=SUMPRODUCT(1*(ISERROR(VALUE(RIGHT(G1:G10)))))`

. I wasn't able to test this with a named table/column, though – Bandersnatch Oct 14 '17 at 16:51excludecells that end with a number - like Area 25. – Bandersnatch Oct 15 '17 at 4:44