1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Count in Excel

Excel's COUNT Function

By

Count in Excel

Count in Excel

© Ted French

COUNT Function Overview

Excel's COUNT function is one of a group of Count Functions that are used to total the number of cells in a selected range that contain a specific type of data.

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).

  1. Enter the following data into cells D1 to D6: 11, twelve, 13, 14

  2. Enter the following data into cell D6: 16

  3. As mentioned, cell D5 is intentionally left blank

  4. Click on cell E1 - the location where the results will be displayed

  5. Click on the Formulas tab

  6. Choose More Functions > Statistical from the ribbon to open the function drop down list

  7. Click on COUNT in the list to bring up that function's dialog box

  8. Drag select cells D1 to D6 in the worksheet to enter the range into the dialog box

  9. Click OK

  10. The answer 4 should appear in cell E1 since only four of the six cells in the range contain numbers

  11. Cell D2, which contains text, and cell D5, which is blank, are ignored by the COUNT function

  12. When you click on cell E1 the complete function =COUNT( D1 : D6 ) appears in the formula bar above the worksheet

©2014 About.com. All rights reserved.