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, ...)

A)Sum_range =  The range of cells containing the values you want to add

B) Criteria_range = The range of cells containing the records you want to check against the criteria

C) 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.

Categories: FORMULA