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
|