Get a running total of only certain cells within a category

[AmandaN1]

I’ve been using an Excel spreadsheet as a digital checkbook register. I’d like to have a cell auto calculate a running total based on a certain value. See the example I made up below. What I'd like to do is under "Total spent on gas monthly" I want it to automatically add the amounts entered under "withdrawal" that has the "Note" of "Gas". How would I do that? Currently, I will filter the note column to show only "Gas" then use =SUM to add those figures up then manually enter that number in the column I want it to be in and then delete the =SUM formula and revert back to show all on the filter. I want that cell to update automatically without all those extra steps.

NOTE	DATE	TRANSACTION	WITHDRAWAL	DEPOSIT	TOTAL		Total Spent on Gas Monthly	Total Spent on Food
Starting Balance					1000.00
Gas	1/1	Gas Station	60.00		940.00
Groceries	1/2	Grocery Store	100.00		840.00
Utilities	1/3	Water, Electric	200.00		640.00
Mortgage	1/4	Bank	400.00		240.00
Gas	1/5	Gas Station	60.00		180.00

 

[Herakles]

Assuming that you range starts in A1 so the 'Total Spent on Gas Monthly' column is column G then
this formula will calculate a running total for Gas.

=IF($A3="Gas",SUMIF($A$3:$A3,"Gas",$D$3:$D3),"")

Put this in cell G3 and drag it down for all rows.

 

[AmandaN1]

I'll give that a try, thanks!

 

[kevin9999]

Book1
	A	B	C	D	E	F	G	H	I
1	NOTE	DATE	TRANSACTION	WITHDRAWAL	DEPOSIT	TOTAL		Total Spent on Gas Monthly	Total Spent on Food
2	Starting Balance					1000
3	Gas	1/1	Gas Station	60		940		60
4	Groceries	1/2	Grocery Store	100		840			100
5	Utilities	1/3	Water, Electric	200		640
6	Mortgage	1/4	Bank	400		240
7	Gas	1/5	Gas Station	60		180		120
Sheet1

Cell Formulas
Range	Formula
H3:H7	H3	=IF($A3="Gas",SUMIF($A$3:$A3,"Gas",$D$3:$D3),"")
I3:I7	I3	=IF($A3="Groceries",SUMIF($A$3:$A3,"Groceries",$D$3:$D3),"")
F4:F7	F4	=F3-D4