Thread: Sorting and summing for a bank statement

I've downloade my bank statement to excel and I want to sort my purchases etc..

One column is the amount debited, the next is where the purchase was made. I want to sort all purchases made at grocery stores, or gas statiosn and sum the purchases for each. I can use sort and subtotal, but that doesnt work if I filled up at 4 different gas stations unless I add another function to sum all the totals of each. Im sure theres an easier way.

Im thinking something along the lines of conditional formatting, if cell contains "gas" then sum the cells of the associated column. But im not sure how to combine the conditional formatting with the formula.

Idealy, each month I would like to download my statement directly to an excel template that would easily/instantly sort all my purchase and sum them.

I've attached an example of purchases, perhaps someone could edit it and reattach it to the thread.

Thanks!

Thanks, this seems to be exactly what im looking for. I've heard of pivot tables before but never thought i would have any use for them. They seem a bit complicated, but i'm sure i'll figure it out perhaps with a little help from you guys.