My guess would be that you actually have a "E6400-2.4-A " in your data, or
something similar.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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 ?