Hi,

You 'might' get away with this depending on your data

=COUNTIF(O1:O275,"*E6400-2.4-A*")

Mike

"GooseMA" wrote:

Hi,

I am using COUNTIF formula and it is miscounting by 1
Example: =COUNTIF(O1:O275,"E6400-2.4-A")

CountIf result: 4
There are actually 5 "E6400-2.4-A" in the O column... Any ideas ?