Excel COUNTIF Multiple Criteria Formula - Free Microsoft Excel Spreadsheet Tips and Tutorials

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 COUNTIFS which is not available in Excel 2003 and earlier versions.

spreadsheets.about.com