Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

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

Excel COUNT Function
Excel's COUNT function allows you to count up the number of cells containing numbers in a selected range.

Excel COUNT - INDIRECT Formula
By combining the INDIRECT and COUNT functions a count formula is with a dynamic range is created. The formula makes it easy to change the range being counted without editing the formula itself.

Excel COUNTA Function
Excel's COUNTA function only counts cells that contain data such as text, numbers, or formulas. It will ignore blank or empty cells in a range. This tutorial includes a step by step example.

Excel COUNTBLANK
The COUNTBLANK function is used to count up the number of blank cells in a selected range.

Excel COUNTIF Function Step by Step Tutorial
Excel's COUNTIF function is used to count the number of data records in a selected range that meet a single criteria.

Excel COUNTIF Function Quick Tutorial
Excel's COUNTIF function is used to count up the number of cells in a selected range that meet specified criteria. This tutorial includes a step by step example of using the COUNTIF function in Excel 2010.

Excel COUNTIFS Function Step by Step Tutorial
Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria.

Excel COUNTIFS Function Quick Tutorial
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 tutorial contains a step by step example of using COUNTIFS in Excel.

Excel AutoCount
This tutorial shows you how to use the AutoCount feature to quickly count numbers in Excel. Included is a step by step example of using the AutoCount function.