|  

» Counting Rows that Match Specific Criteria for Each Column

Problem:

Range A2:C7 contains the ID's, genders and ages of all the people in the room.
Cells F1:F2 contains the criteria according to which we would like to count.
As different counting criteria are required, we would vary the values stored in cells F1:F2.
What single formula will count the number of rows matching the variable criteria stored in cells F1:F2?

Solution:

Use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((B2:B7=F1)*(C2:C7=F2))
Screenshot // Counting Rows that Match Specific Criteria for Each Column
Counting Rows that Match Specific Criteria for Each Column

Rate This Tip
12 34 5
Rating: 3.45     Views: 27338
No comments have been submitted.
Name
Comment Title
Comments