Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to SUMIFS

SUMIFS challenge

Your goal: Total paid amounts from one region.

Total paid amounts from one regionSelect matching values directly in the worksheet0 records selected
Region
East
Status
Paid
Click a value to select its whole record. Drag or use Range for several records. Drag from selected cells to deselect.
#
1
2
3
4
5
6

Select the matching values

Click a value in each row that meets all the conditions. Click again to remove it; the whole record stays together.

How these records contribute

Add the amount from every matching row. A matching refund still reduces the total.

Select matching values in the worksheet.

Selected total0
0 rows selected

SUMIFS parameters

SUMIFS(sum_range, criteria_range1, criteria1, [criteriaRange2], [criteria2])

The range of cells to sum.

In this example
A2:A6
Where it comes from
Reads the following cells in the displayed worksheet.
  • A2:A6 — Column A (Amount), rows 2–6.