1. Computing & Technology

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 COUNTA Function

Excel 's COUNTA function allows you to count up the number of cells containing numbers, dates, or text labels in a selected range.

Excel COUNTBLANK

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

Excel COUNTIF

The COUNTIF function combines Excel's IF and COUNT functions to count up the number of data records in a selected range meet a specified criterion.

Excel COUNTIFS Function

The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of data records in a selected range that meet two or more specified criteria.

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.

Discuss in my forum

©2012 About.com. All rights reserved.

A part of The New York Times Company.