Countif with 3 different options

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

Guest

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
 
I am not sure what you want but mayb
=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.
 
Perhaps this?

=SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"}))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
 
=COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-")
?
 
Thanks Ron,

this is the one I have used even though all the other answers seem to work
Cheers
 
Thanks bj
--
Smudge


bj said:
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.
Click to expand...
 
I'm glad I could help........Thanks for the feedback.

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)
 
Back
Top