countif w/ 2 conditions

[Ragdyer]

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

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

 

[rp]

is it possible to use countif w/ 2 conditions?

 

[Don Guillett]

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

 

[Don Guillett]

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



--
Don Guillett
SalesAid Software
(e-mail address removed)

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