countif problem

S

Scott@CW

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

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

Am I using the the wrong formula
 
T

Teethless mama

Try this:

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

Peo Sjoblom

Try

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


--


Regards,


Peo Sjoblom
 
S

Scott@CW

I got the lovely "#value!" error.

Teethless mama said:
Try this:

=SUM(COUNTIF('Working
Sheet'!M4:M106,{"2110200110","2110200121","2110200310","2110220410"}))
Click to expand...
 
S

Scott@CW

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

Teethless mama said:
Try this:

=SUM(COUNTIF('Working
Sheet'!M4:M106,{"2110200110","2110200121","2110200310","2110220410"}))
Click to expand...
 
T

Tyro

COUNTIF works with one criterion. You could use a formula like:
=COUNTIF(WorkingSheet!M4:M106,"2110200110")+COUNTIF(WorkingSheet!M4:M106,"2110200121")+COUNTIF('WorkingSheet'!M4:M106,"2110200310")+COUNTIF('WorkingSheet'!M4:M106,"2110220410")
 
Top