Thread: countif problem
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default countif problem
COUNTIF works with one criterion. You could use a formula like:
=COUNTIF(WorkingSheet!M4:M106,"2110200110")+COUNTI F(WorkingSheet!M4:M106,"2110200121")+COUNTIF('Work ingSheet'!M4:M106,"2110200310")+COUNTIF('WorkingSh eet'!M4:M106,"2110220410")

"Scott@CW" wrote in message
...
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


Reply With QuoteReply With Quote