Related article: Excel 2007 COUNT Function
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.
Example Using Excel's COUNT Function:
Note: For help with this example, see the image to the right.
- 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.
- 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.
