Tuesday, 14 October 2014

How to use the COUNT Function in Microsoft Excel 2010

The COUNT function can be used to count the number of numeric entries in a range of data. For example, in a wages worksheet you could determine how many employees have worked over 40 hours. The formula syntax for the COUNT function is: COUNT (value1, value2, . . . . . . .).

To use the COUNT function, do the following on your worksheet:
1. Select the cell where you want to place the count value.
2. On the [Formulas] tab, in the [Function Library] group, click [Insert Function].
The Insert Function dialog box will be displayed as shown below:

3. Having COUNT function highlighted, click OK.
 The Function Arguments dialog box will be displayed:

4. To select the range for [value1], click on the [Collapse Dialog] button.
5. Choose the range (for example B5:B17), then press [Enter].
6. Repeat steps 4 - 5 for each value, that is, [value2], [value3], . . . . .
7. Click OK to accept the function arguments. The COUNT value will be automatically inserted in the cell you have selected in step 1.