Microsoft Excel articles et conseils

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!

Nous serions ravis de communiquer avec vous!