Help with function for aggregating spending data

[SnowToad23]

Hello,
I've been doing up an Excel spreadsheet to track my expenditures lately (am a Uni student)
I have four columns containing all the relevant data as follows:

Date | Description | Price | Category


And I just add in stuff under there. On a new sheet I want to have this data organised into such as the total amount spent per category, or total amount spent per week (change over time)
Then I can graph these and see what's going on. It's easy enough with a static list of data but I want it to work so that each time I add new entries it automatically updates etc.
I have 6 or so categories I'm using, such as Food, Transport, Indulgence, Misc, etc.

Any help with this would be great!

Cheers

[JBeaucaire]

The function you're looking for is SUMIF().

[SnowToad23]

Cheers, that does sound about right, I'll give it a go!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.