Thread: countif problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott@CW Scott@CW is offline
external usenet poster
 
Posts: 62
Default countif problem

I am using the below formula and it seems to only be counting the first number.

=COUNTIF('Working
Sheet'!M4:M106,{"2110200110","2110200121","2110200 310","2110220410"})

Am I using the the wrong formula