Tuesday, November 20, 2012

How to Use Countif on Excel 2003


1. Open Excel 2003 and select a workbook. Click 'File' on the menu bar. Select 'Open.' Browse your computer file and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.
2. Click on a cell to enter the Countif function. Enter the following formula in the cell: '=Countif.' Notice the Excel hint that appears beneath the formula. Hints serve as a mini guide to assist you as you enter the formula. Click the 'Insert Function' button on the formula bar. The Function Arguments dialog box appears.
3. Click the box with the red arrow in the 'Range' field. The Function Arguments dialog box becomes minimized. Highlight the range that you want to count. When you stop highlighting, the Function Arguments dialog box reappears. Enter your criteria in the Criteria box. In this example, you will count all values that are greater than 1000. So to notate greater than, enter the '>' symbol. In this criteria, enter the following: '>1000.' Click 'OK.' Excel displays the results of the Countif function.

Blogger news