1. Computing

Excel COUNTIF Function Step by Step Tutorial

By , About.com Guide

2 of 7

Entering the Tutorial Data
Excel COUNTIF Function Tutorial

Excel COUNTIF Function Tutorial

© Ted French

Entering the Tutorial Data

The first step to using the COUNTIF function in Excel is to enter the data.

Enter the data into cells C1 to E11 of an Excel worksheet as seen in the image above.

The COUNTIF function and the search criteria (greater than 250 orders) will be added to row 12 below the data.

Note: The tutorial instructions do not include formatting steps for the worksheet.

This will not interfere with completing the tutorial. Your worksheet will look different than the example shown, but the COUNTIF function will give you the same results.

©2013 About.com. All rights reserved.