countif w/ 2 conditions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rp - 21 Oct 2004 06:42 GMT

is it possible to use countif w/ 2 conditions?

--
rp

Reply to this Message

Ragdyer - 21 Oct 2004 06:56 GMT

Not exactly, but you could use 2 of them, and add them together.

=COUNTIF(A1:A100,"A")+COUNTIF(A1:A100,"B")

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> is it possible to use countif w/ 2 conditions?
>
> --
> rp

Reply to this Message

Don Guillett - 21 Oct 2004 13:51 GMT

try
=sumproduct((rngA={"joe","bill"})*(rngb))

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> is it possible to use countif w/ 2 conditions?
>
> --
> rp

Reply to this Message

Don Guillett - 21 Oct 2004 13:53 GMT

this would sum rngB
=sumproduct((rngA={"joe","bill"})*(rngb))
to count
=sumproduct((rngA={"joe","bill"})*1)

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> try
> =sumproduct((rngA={"joe","bill"})*(rngb))
[quoted text clipped - 3 lines]
> > --
> > rp

Reply to this Message