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

--

HTH

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


"Abra" wrote in message
...
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