In previous articles, I have talked about how to count unique/unique distinct/duplicates in a column/columns/range. In this article I count matching values using criteria.

Formula in B16:

=SUMPRODUCT(--(A4=A8:A14)) + ENTER

Formula in B32:

=SUMPRODUCT(--(A20=A24:A30),--(B20=B24:B30)) + ENTER

Formula in B51:

=SUMPRODUCT(--(A37=A43:A49),--(B37=B43:B49), --(C37<C43:C49), --(C39>C43:C49)) + ENTER

Download excel file for this tutorial.

Count matching rows.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

SUMPRODUCT(array1, array2, )
Returns the sum of the products of the corresponding ranges or arrays

Related posts:

1. Count matching cell values in two columns in excel
2. Formula for matching a date within a date range in excel
3. Count date records between two dates in a range in excel
4. Sum values between two dates with criteria in excel
5. Lookup two index columns in excel
6. Count unique distinct values in three columns combined in excel
7. Return value if in range in excel
8. Count unique distinct values in two columns in excel
9. Count unique distinct values in two columns with date criteria in excel
10. Count records between two dates in excel