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.
If the word "gas" is in cell R1, then this formula in S1 would give you your total looking at columns A and B:
=SUMIF($A$1:$A$100, "*" & R1 & "*", $B$1:$B$100)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks