Count rows

K

keith6973

Is there any formula to have excel count the number of rows in a rang
where all the cells in that row meet some criteria? Countif will no
work because there are multiple criteria
 
J

JulieD

look at the SUMPRODUCT function
e.g.

=SUMPRODUCT(--(A1:A100="Cat"),--(B1:B100="Dog"),--(C1:C100>100))
will count all the items with Cat in column A, Dog in column B and a number
greater than 100 in column C
However, all the ranges must be the same size & you can't use wildcards

Hope this helps
Cheers
JulieD
 
Top