Sorting and summing

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.