One way

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

--
Regards,

Peo Sjoblom

(No private emails please)


"PhilH" wrote in message
...
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.

"PhilH" wrote:

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 ?