COUNT Function Overview
Each member of this group does a slightly different job and the COUNT function's job is to total only those cells that contain numbers.
The function ignores empty cells and those that contain text data.
If a number is later added to an empty cell the function will be automatically updated to include this new data.
Note: dates, times, functions, and formulas are stored as numbers in Excel.
They will, therefore, be counted by the COUNT function if present in the selected range.
COUNT Function's Syntax and Arguments
The syntax for the COUNT function is:
=COUNT( Range )
The function has only one argument:
Range - the group of cells the function is to count.
COUNT Function Example
As can be seen in the image above, this example will find the number of cells in the range D1 to D6 that contain numbers. It will ignore those cells that are blank (D5)or contain text data (D2).
- Enter the following data into cells D1 to D6: 11, twelve, 13, 14
- Enter the following data into cell D6: 16
- As mentioned, cell D5 is intentionally left blank
- Click on cell E1 - the location where the results will be displayed
- Click on the Formulas tab
- Choose More Functions > Statistical from the ribbon to open the function drop down list
- Click on COUNT in the list to bring up that function's dialog box
- Drag select cells D1 to D6 in the worksheet to enter the range into the dialog box
- Click OK
- The answer 4 should appear in cell E1 since only four of the six cells in the range contain numbers
- Cell D2, which contains text, and cell D5, which is blank, are ignored by the COUNT function
- When you click on cell E1 the complete function =COUNT( D1 : D6 ) appears in the formula bar above the worksheet