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.
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):
EXAMPLE 2: Formula example if referring to a regular data range:
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.