1. Home
  2. Computing & Technology
  3. Spreadsheets

Count Functions

Excel's Count Functions allow you to count up the number of cells being used for a specific purpose such as the number of cells containing number values or the number of blank cells in a data range.
Count in Excel
Excel has a number of Count Functions that will total the number of cells in a selected range. The reason that there is more than one COUNT function is that each does a slightly different job - one counts only numbers, another counts only blank cells, and so on. What each one does is outlined below.
Excel 2007 COUNTIF
The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet a certain criterion.
Excel 2007 COUNTBLANK
The COUNTBLANK function, one of Excel's COUNT functions, is used to count up the number of blank cells in a selected range.
Excel 2007 COUNT Function
Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range.
Excel 2007 COUNTA Function
Excel 2007's COUNTA function allows you to count up the number of cells containing numbers, dates, or text labels in a selected range.
Excel 2007 COUNTIFS Function
The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion.
Count Numbers in Excel
This article shows you how to use the AutoCount feature to count numbers in Excel. Included is a step by step example of using the AutoCount function.
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

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

All rights reserved.