﻿ DJH Training & Application Solutions | Excel CountIf Function  MICROSOFT EXCEL COUNTIF FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use COUNTIF to conditionally count a range of values or text, based on a single criterion

Would you like to know how many employees work in a particular department? Or how many sales were made by a specific rep? Or perhaps how many sales came in over or under target?  COUNTIF will quickly and easily accomplish this!

In the example below, we count the number of employees by department.

Step 1. Set up your data correctly, preferably converting it to a table Step 2. Add the COUNTIF formula the the Number of Employees column in the table below. DETAILED EXPLANATION

SYNTAX: =COUNTIF(Range in which Criteria is found ,Criteria)

EXAMPLE 1: Formula example if referring to a table range (tables are preferable, as will expand/contract as add/remove data):

=COUNTIF(tblEmployeeData[Department],[@Department])

EXAMPLE 2: Formula example if referring to a regular data range:

=COUNTIF(\$D\$4:\$D\$22,E27)

OR

=COUNTIF(\$D\$4:\$D\$22,"Accounting")  