Count matching values in one or more columns in excel
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:
- Count matching cell values in two columns in excel
- Formula for matching a date within a date range in excel
- Extract a unique distinct list by matching items that meet a criterion in excel
- Count cell blocks in excel
- Count date records between two dates in a range in excel
- Sum values between two dates with criteria in excel
- Lookup two index columns in excel
- Return value if in range in excel
- Merge two columns with possible blank cells in excel (formula)
- Count unique text values in a range containing both numerical and text values





Leave a Reply