Excel Function

SUMIFS

Sums values that meet multiple conditions.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

sum_range

Required

Specify the range of values to sum.

criteria_range1

Required

Specify the range for the first condition.

criteria1

Required

Enter the match condition for criteria1.

criteria_range2

Optional

Specify the range where criteria_range2 is evaluated.

criteria2

Optional

Enter the match condition for criteria2.

Practice Preview

Use SUMIFS to aggregate Sales in column D where Category matches Food and where Sales matches >=1000. You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CCategory	DSales
2	P001	Apple	Food	1200
3	P002	Banana	Food	980
4	P003	Notebook	Stationery	450
5	P004	Pen	Stationery	300
6	P005	Grapes	Food	1500
7	P006	Ruler	Stationery	250
8	P007	Peach	Food	860

How to Use (Formula)

=SUMIFS(D2:D8, C2:C8, "Food", D2:D8, ">=1000")

Result

2700

Practice This Function

Start Function Practice Back to Function List

SUMIFS FAQ

How do I use SUMIFS in Excel?

Use SUMIFS when you want to sum values with multiple conditions. Enter Sum range, Criteria range 1, Criteria 1 in that order, then add optional arguments when needed.

Where can I practice SUMIFS?

Use the "Start Function Practice" button to jump straight into SUMIFS drills.

What arguments does SUMIFS use?

The main arguments are Sum range, Criteria range 1, Criteria 1, Criteria range 2, Criteria 2. Start with the required ones, then add optional arguments if needed.