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" <(E-Mail Removed)> wrote in message
news:B3933974-7CCC-4168-BDE6-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:E25669E5-FDE1-40B9-8AD7-(E-Mail Removed)...
> 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 ?