1. Computing

Excel COUNTIFS Function Step by Step Tutorial

By

2 of 9

Entering the Tutorial Data
Excel COUNTIFS Function Step by Step Tutorial

Excel COUNTIFS Function Step by Step Tutorial

© Ted French

Entering the Tutorial Data

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

For this tutorial enter the data seen in the image above into cells D1 to F11 of an Excel worksheet.

In row 12 below the data we will add the COUNTIFS function and the two search criteria:

  • sales agents from the East sales region
  • more than 250 orders placed for the year

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 COUNTIFS function will give you the same results.

©2014 About.com. All rights reserved.