Why are you starting a NEW thread?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GooseMA" wrote in message
...
Hello! CountIf is miscounting by qty 1.
EX: =COUNTIF(O1:O275,"E6400-2.4-A")

CountIf states qty. 4
Answer is 5.