Spending per category with SUMIF

Premium

In F2, total the amounts for the category in E2 with SUMIF. Lock the two ranges with $, so the formula still covers the whole list when you fill it down to F4.

F2
ABCDEFG
1Item Category Amount Category Spent
2Movie tickets Fun 180 Food
3Supermarket Food 312 Transportation
4Bus pass Transportation 375 Fun
5Bakery Food 289
6Gas Transportation 450
7Takeout Food 199
8

Premium lesson

Unlock Budget and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?