Services offered worldwide
or
Your partner in computer software training & application development
for over 25 years
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 ,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)
​
​
​
​
​
​
​
​
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.