How can you use count with an array formula similar to using sum

[Guest]

I understand how to a mutiple condition sum using an array formula following
the format that is created by the conditional simif wizard. Can count use
multiple conditions in the same way, and if so how ?

 

[Ragdyer]

Yes, you can have multiple criteria included within the Countif() function,
using it in conjunction with the Sum() function.

Count the items in Column A, where their color, in Column B, is *either*
Red, or Blue, or White:

=SUM(COUNTIF(B:B,{"Red","White","Blue"}))

This is *not* an array formula!

 

[Guest]

Thanks, but what if you have a third column that contains names and you only
want to count items that relate to either "Red" or "Blue" for column B and
"Dave " or "Steve" for column C.

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--((B2:B200="Blue")+(B2:B200="Red")>0),--((C2:C200="Dave")+(C2:C200="Steve")>0))

--
Regards,

Peo Sjoblom

(No private emails please)