Excel > Functions

SUMIFS Function

The Excel SUMIFS function is similar to the SUMIF function. It adds up the values from a given range that meets multiple criteria.

The syntax for the SUMIFS function is:

=SUMIFS(sum_range, criteria_range1, criteria1, ...)

Argument	Purpose
Sum_range	The range of cells containing the values you want to add
Criteria_range	The range of cells containing the records you want to check against the criteria
Criteria	The criteria to determine whether the value is added or not

The example below shows the SUMIFS function being used to sum the order amounts by the company Carpet World.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides