Thread: COUNTIF is Off by 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GooseMA GooseMA is offline
external usenet poster
  
Posts: 4
Default COUNTIF is Off by 1
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 ?
Reply With QuoteReply With Quote