1. 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 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
Excel's COUNTIF function is used to count the number of data records in a selected range that meet a single criteria.

Excel COUNTIFS Function
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 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.

Calculate the Percentage of Specific Values in Excel
Find the percentage of yes or no responses in a data range using the COUNTIF and COUNTA functions in Excel. The same formula can be used to find the percentage of any one value - not just yes and no.

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.

You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.