Related tutorials: Excel 2007 / 2010 COUNT Function List
Excel's COUNT function is one of a group of Count Functions that can be used when you need to total the number of cells in a selected range.
The COUNT function will add up the number of cells in a selected range that contains numbers.
The function is written as follows:
=COUNT ( argument )
The argument for this function is the range of cells to be totaled.
COUNT also ignores empty cells in the selected range. If number data is later added to an empty cell in the range, the count total is automatically updated.
Excel's COUNT Function Example
For help with this example, see the image above.
- 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.
