Simple Formula for Budget Sheet

[aherzog]

Let's say I want to make a budget sheet of my monthly expenses. Column D are the dollar amounts I spent, and column H are the categories I bought.

For example, column D is $10 and column H is labeled Food.

What formula can I use to create a third column, let's say column J, which will show me the total of all entries in D which were labeled as Food in column H?

This is assuming I have multiple money entries in column D, and multiple categories in column H such as entertainment, bills, etc.

 

[Scott T]

Book1
	D	E	F	G	H
2	10	food		Food	25
3	200	rent		Rent	200
4	20	gas		gas	25
5	15	Food
6	5	gas
7
8
Sheet1

Cell Formulas
Range	Formula
H2:H4	H2	=SUMIF($E$2:$E$10,G2,$D$2:$D$10)