how do i countif on multiple criterea?
"Dan Shoemaker" wrote:
TY
"Bob Phillips" wrote:
=SUMPRODUCT(--(rng1="text"),--(rng2=number))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Dan Shoemaker" wrote in message
...
I would like to know how to count if 2 criterea are true in a range of
cells
I was wondering if 3 or more critereas are true in a range of cells... how can i get them to count value of 1... instead of 3
|