Excel COUNTIF Multiple Criteria Formula - Spreadsheets - About.com This tutorial uses the SUMPRODUCT function to count up the number of cells in selected ranges that meet multiple criteria in Excel. It can be used in place of ...