countif problem
 

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

countif problem
 

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

countif problem
 

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

countif problem
 

I got the lovely "#value!" error.

"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

countif problem
 

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

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

countif problem
 

See the other 2 answers


--


Regards,


Peo Sjoblom




"Tyro" wrote in message
. ..
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