How to Count Multiple Criteria in Excel 2003

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.