SUMIFS

25 min

Add up numbers that match multiple conditions at once.

Step 1 of 4

In this lesson

—SUMIFS(sum_range, criteria_range1, criteria1, ...)
—Sum range comes first (unlike SUMIF)
—All conditions must be true to include a value
—Great for building reports by region, month, and type

Live practice sheet

	A	B	C	D	E	F	G	H	I
1	Date	Region	Order #	Revenue
2	2026-01-02	North	1001	1250
3	2026-01-03	South	1002	3400
4	2026-01-05	North	1003	8700
5	2026-01-08	West	1004	5200
6	2026-01-11	North	1005	11500
7	2026-01-13	South	1006	18100
8
9
10				20200
11
12
13
14

The highlighted cells show where this lesson's formula lives. Use the prompts on the left to rebuild it yourself.