wait, i retyped it and it worked! Thank you.

"Teethless mama" wrote:

Try this:

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


"Scott@CW" wrote:

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