How do I count number of cels the matches 2 conditions ?

[Guest]

How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not
the sum of the cels.
Thanks

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="value1"),--(A1:A100="value2"))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ragdyer]

You could use Countif() in conjunction with Sum() to count against any
number of conditions:

=SUM(COUNTIF(A1:A100,{"cond#1","cond#2","cond#3"}))