Try

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


--


Regards,


Peo Sjoblom



"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