Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem w countif | Excel Discussion (Misc queries) | |||
COUNTIF problem with NOW() | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions |