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 ?

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!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PhilH" wrote in message
...
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 ?

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 ?

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 ?