1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 AutoCOUNT
Counting Numbers in Excel

By Ted French, About.com

Excel 2007's AutoCOUNT Function

Excel 2007's AutoCOUNT Function

© Ted French

The AutoCOUNT feature in Excel provides a quick way to count numbers in Excel. What it does is count how many cells contain numbers in a given range of data.

The syntax for AutoCOUNT is the same as the COUNT function.

= COUNT ( Number1, Number2, ... Number255 )

Up to 255 numbers can be entered into the function.

Example Using Excel's AutoCOUNT Feature:

Note: For help with this example, see the image above and to the right.

  1. Enter the following data into cells C1 to C6:
    11, twelve, 13, 14, fifteen, 16
  2. Make sure that cell C7 - the location where the results will be displayed is blank.

  3. Drag select cells C1 to C6 in the spreadsheet.

  4. Click on the Home tab.

  5. Click on the down arrow beside the AutoSum button on the ribbon to open the drop down menu.

  6. Click on COUNT Numbers in the menu to enter the COUNT function into cell C7.

  7. The answer 4 should appear in cell C7 even though we have entered data into six cells.

  8. As mentioned above, the COUNT function only totals up those cells containing numbers. The function ignored the data in cells C2 and C5 because it was text.

  9. Click on cell C7 and the complete function = COUNT (C1 : C6) appears in the formula bar above the worksheet.


Related Articles
More Spreadsheets Quick Tips
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Count Functions
  6. Count in Excel - Count Numbers in Excel

©2009 About.com, a part of The New York Times Company.

All rights reserved.