countif problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

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

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


--


Regards,


Peo Sjoblom
 
I got the lovely "#value!" error.

Teethless mama said:
Try this:

=SUM(COUNTIF('Working
Sheet'!M4:M106,{"2110200110","2110200121","2110200310","2110220410"}))
Click to expand...
 
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...
 
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")
 
Back
Top