Count Number of Rows

[Boying Opaw]

In a given range, I only want to count the rows when certain columns satisfy
corresponding criterias. How do I do this?

Say I have Rows 1 to 10 and Columns A to D. I only want to count the rows
when the content of A = criteriaA and the content of B = criteriaB. What
formula do I use?

 

[T. Valko]

Use cells to hold your criteria.

F1 = criteriaA
G1 = criteriaB

Then:

=SUMPRODUCT(--(A1:A10=F1),--(B1:B10=G1))