Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
Hi everyone,
What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
I am not sure what you want but maybe
=countif(dumpers!$E:$E,"3c-")+countif(dumpers!$E:$E,"3b-")+countif(dumpers!$E:$E,"3a-") or =sum(if(or(dumpers!$E:$E={"3c-"."3b-","3a-}),1,0)) entered as an array control-shift-enter you cant have multiple criteria in one countif. "Smudge" wrote: Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
Perhaps this?
=SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"})) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) "Smudge" wrote in message ... Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
=COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-")
? -- David Biddulph "Smudge" wrote in message ... Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
Thanks Ron,
this is the one I have used even though all the other answers seem to work Cheers -- Smudge "Ron Coderre" wrote: Perhaps this? =SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"})) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) "Smudge" wrote in message ... Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
Thanks bj
-- Smudge "bj" wrote: I am not sure what you want but maybe =countif(dumpers!$E:$E,"3c-")+countif(dumpers!$E:$E,"3b-")+countif(dumpers!$E:$E,"3a-") or =sum(if(or(dumpers!$E:$E={"3c-"."3b-","3a-}),1,0)) entered as an array control-shift-enter you cant have multiple criteria in one countif. "Smudge" wrote: Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
Thank you David
-- Smudge "David Biddulph" wrote: =COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-") ? -- David Biddulph "Smudge" wrote in message ... Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with 3 different options
I'm glad I could help........Thanks for the feedback.
Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Smudge" wrote in message ... Thanks Ron, this is the one I have used even though all the other answers seem to work Cheers -- Smudge "Ron Coderre" wrote: Perhaps this? =SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"})) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) "Smudge" wrote in message ... Hi everyone, What's the syntax for adding 3 different criteria to a countif function please? =COUNTIF(dumpers'!$E:$E,"3c-") Dumpers can be assigned 1-10 but also 3 levels a-c within this TIA -- Smudge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Options | Excel Discussion (Misc queries) | |||
Web Options? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
what are my options? | Excel Discussion (Misc queries) |