1. Computing

Excel COUNTIF Function Step by Step Tutorial

By

1 of 7

How the COUNTIF Function Works
Excel COUNTIF Function Tutorial

Excel COUNTIF Function Tutorial

© Ted French

How the COUNTIF Function Works

Related Tutorial: Text only version - Excel COUNTIF Function

The COUNTIF function combines the IF function and COUNT function in Excel. This combination allows you to count the number of times specific data is found in a selected group of cells.

The IF portion of the function determines what data meets the specified criteria and the COUNT part does the counting.

COUNTIF Function Step by Step Tutorial

This tutorial uses a set of data records and the COUNTIF function to find the number of Sales Reps who have more than 250 orders for the year.

Following the steps in the tutorial topics below walks you through creating and using the COUNTIF function seen in the image above to count the number of sales reps with more than 250 orders.

Tutorial Topics

©2014 About.com. All rights reserved.