Let me see if I can make sense of what I need.
I have created a spreadsheet with each credit card statement throughout a year (Jan-Dec) and then at the end I have a spreadsheet that breaks down monthly expenses for the whole year into the correct expense account so it has a year end summary on one sheet showing what was spent in each expense account with totals for each month and also a running total of what was spent in each expense account for the entire year.
Example
(tab 1)
Jan 23-Feb 22
Date Vendor Expense Acct Desc Total
1/24/13 Presto 82400 Fuel $60.00
2/4/13 McDonalds 82200 Lunch Meeting $15.00
(tab 13)
End of Year Summar
Expense Acct Jan Feb March April May June July Aug Sep Oct Nov Dec Total
81000
82000
82100
82200
82300
82400
Fuel
Plane
82500
83000
84000
Total
What I am looking to do is for example, when we purchased 60.00 fuel from Presto, it be applied into the summary under Fuel 82400, being added to the previous total as a running total and that also add to the totals for the column and the row. I have no idea where to start. I need help formulating formulas. Hope someone can help!
Bookmarks