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 ?
|