SUMIFS

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 14 of 28.

SUMIFS(sum_range, criteria_range1, criteria1, ...) adds amounts only when all the conditions hold. Unlike SUMIF, its sum range comes first. Keep every range the same size and row alignment.

A2 contains East, A3 contains East, A4 contains West, B2 contains Paid, B3 contains Open, B4 contains Paid, C2 contains 20, C3 contains 30, C4 contains 90.

Example: =SUMIFS(C2:C4,A2:A4,"East",B2:B4,"Paid").

Only the East-and-Paid row contributes its amount 20.

In SUMIFS, put the sum range first, then aligned range-and-criterion pairs.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Sum sales C2:C5 for rows where region A2:A5 matches E2 and status B2:B5 is Paid. Put the total in F2.

Enter formulas in the highlighted output cells: F2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1