﻿ DJH Training & Application Solutions | Excel SumIf Function  MICROSOFT EXCEL SUMIF FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use SUMIF to conditionally sum a range of values, based on a single criterion

Would you like the most current sales figure for a certain product? Or perhaps the quantity on hand of an item? SUMIF makes it a snap!

In the example below, we sum the employee salaries by department.

Step 1. Set up your data correctly, preferably converting it to a table Step 2. Add the SUMIF formula the the Salaries column to arrive at the results below DETAILED EXPLANATION

SYNTAX: =SUMIF(Range in which Criteria is found ,Criteria, Sum Range if different from Range)

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

=SUMIF(tblEmployeeData[Department],[@Department],tblEmployeeData[Salary])

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

=SUMIF(\$D\$4:\$D\$22,E27,\$F\$4:\$F\$22)  