Count rows

[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

 

[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

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html