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.
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.
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.
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's COUNT function allows you to count up the number of cells containing numbers in a selected range.
Excel 2007's COUNTA function allows you to count up the number of cells containing numbers, dates, or text labels in a selected range.
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.
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.
