Count Number of Rows

  • Thread starter Thread starter Boying Opaw
  • Start date Start date
B

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?
 
Use cells to hold your criteria.

F1 = criteriaA
G1 = criteriaB

Then:

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