Related tutorial: Excel 2007 / 2010 COUNT Function
Excel's COUNT function is one of a group of Count Functions that is used to total the number of cells in a selected range.
Specifically, the COUNT function totals only those cells that contain numbers.
The function ignores blank cells or those containing text data.
The function is written as follows:
=COUNT ( range )
The argument for this function is the range of cells to be totaled.
As mentioned, the COUNT function ignores empty cells in the selected range, but if number data is later added to an empty cell in the range, the count total is automatically updated.
COUNT Function Example
- Enter the following data into cells C1 to C6: 11,12,13,14,15,16.
- Click on cell C7 - the location where the results will be displayed.
- Type =count( in cell C7.
- Drag select cells C1 to C6 with the mouse pointer.
- Type the closing bracket ")" after the cell range in cell C7.
- Press the ENTER key on the keyboard.
- The answer 6 appears in cell C7.
- If you click on cell C7 the complete function =COUNT(C1:C6) appears in the formula bar.
Note: Since dates, times, and formulas are stored as numbers in Excel, the COUNT function will include any cells containing these types of data in the total.