Countif with 3 different options

S

Smudge

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
 
B

bj

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.
 
R

Ron Coderre

Perhaps this?

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

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

Regards,

Ron
Microsoft MVP (Excel)
 
D

David Biddulph

=COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-")
?
 
S

Smudge

Thanks Ron,

this is the one I have used even though all the other answers seem to work
Cheers
 
S

Smudge

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...
 
R

Ron Coderre

I'm glad I could help........Thanks for the feedback.

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)
 
Top