How to Count Multiple Criteria in Excel 2003

Microsoft Excel is a database software that allows you to create, edit and maintain spreadsheets for yourself and your company. Excel 2003 lets you insert array formula in the formula bar to perform counting and complicated mathematical tasks. You can count the number of cells that satisfy multiple criteria from different ranges in Excel. The syntax is simple and easy to execute. Note that you may require administrative rights to run a formula in certain Excel spreadsheets.

Instructions

1. Open your Excel spreadsheet.

2. Locate the formula bar at the top of the spreadsheet. It will have an "fx" symbol on the left.

3. Type the following syntax in the formula bar (without the quotes):

   "=countif(range,criteria)"

   Replace "range" with the range of cells that you want the Excel to include (e.g. "A1:A20") and replace "criteria" with the criteria you wish to use for the formula (e.g. ">20" where ALL values greater than 20 will be taken into account).

4. Press "Ctrl + Shift + Enter" to enter the array.

References

• Excel Tip: Counting Based on Multiple Criteria
• Microsoft: Putting Basic Array Formulas to Work
• OZ Grid: Excel Count If Multiple Criteria