6) Count Function

Count Function

Whenever you want to count the number of instance within the range of cells, then the function ‘COUNT’ can be used. This function counts only the arguments that has numerical value. For example when you want to find the total of boys, among the whole list. To do this:

1. Sort the table such that all the boys are arranged as a list.
2. Select the cell where you want the solution to be displayed.
3. Select the function ‘count’ under the category ‘statistical’ in the formula wizard.

4. Select the range of cells of which the instances need to be counted (Eg: corresponding to male) which has a numerical value since count function counts only argument that has numbers.

5. Click OK and the counted numbers gets displayed

.