Budget Help

[bflannery23]

I have exhausted my limited knowledge and google expertise to figure this out.

I'm trying to create a spreadsheet of my expenses (example attached). I want the Columns to be: Date, Place, Category, and Price. Then use the rows for each expense.

I'm having an issue being able to search the Category Column for everything labeled "Grocery", then have all "Grocery" values (from the Price column) be tallied up into a total under the Total Grocery cell.

I think my example will explain it better.

If you have any ideas, please let me know.Example Budget.xlsx

[bflannery23]

A short way would be to sort by categories and then get the total amount, but I would like to be able to keep a running tally. Thanks

[alansidman]

You can use the Sumif function.

Look here http://www.techonthenet.com/excel/formulas/sumif.php

[bflannery23]

That was exactly what I needed. Thanks for the help.