Count Cells that Match multiple criteria In Excel 2007 and later versions, you can use the COUNTIFS function to count rows that meet two or more criteria.