top of page

# Microsoft Excel SUMIF Function 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 to the Salaries column for the results in the table below. DETAILED EXPLANATION

SYNTAX: =SUMIF(Range in which Criteria is found ,CriteriaSum 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)

Give the SUMIF function a try, and let us know if you have any questions, or would like to arrange training on this

or other Excel functions and features!

© 2018 DJH Training & Application Solutions Inc.

bottom of page