Math & trig › SUMIF14 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeSUMIF

SUMIF: spending by category

Citra recently graduated and works in Jakarta. She logs all her September expenses in Excel and wants the total per category to see where most of her salary goes.

Task

Fill G2:G5 with the total spending for each category in F2:F5, using SUMIF. Write the formula in G2 and copy it down, so lock the data ranges.

Cells to fillG2:G5

Required functionsSUMIF

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
The shape: SUMIF(criteria_range, criteria, sum_range). The criteria range is the category column and the sum range is the amount column.
Hint 2
No need to retype the criteria: just refer to the category cell in F2.
Hint 3
Lock both data ranges with $ (for example $C$2:$C$11), but keep F2 relative so it moves down.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

G2:G5

=SUMIF($C$2:$C$11,F2,$D$2:$D$11)

Write it in G2, then fill down to G5.

Explanation

=SUMIF($C$2:$C$11,F2,$D$2:$D$11) finds the rows whose category matches F2 and adds up their amounts. The criteria range and the sum range must be the same size. Without $, the ranges shift when copied and some rows get skipped. For more than one condition, such as category and date, use SUMIFS.

Starting worksheet: Sheet1
Row	A	B	C	D	F	G
1	Date	Description	Category	Amount	Category	Total
2	01/09/2026	September rent	Rent	1,500,000	Food
3	02/09/2026	Lunch at a warteg	Food	25,000	Transport
4	03/09/2026	Ride-hailing to the office	Transport	18,000	Rent
5	05/09/2026	Movie night	Entertainment	50,000	Entertainment
6	06/09/2026	Groceries	Food	85,000
7	08/09/2026	Commuter train top-up	Transport	100,000
8	10/09/2026	Iced milk coffee	Food	22,000
9	13/09/2026	Music streaming plan	Entertainment	54,990
10	15/09/2026	Ride-hailing home	Transport	23,500
11	20/09/2026	Dinner with friends	Food	120,000
12
13
14

Fill in the requested cell, then press Check answer.

Validation result