+ Reply to Thread
Results 1 to 2 of 2

Formula-applying monthly expenses to an end of year summary sheet

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Formula-applying monthly expenses to an end of year summary sheet

    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!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula-applying monthly expenses to an end of year summary sheet

    First suggestion is to apply a PIVOT TABLE to this data. Lots of tutorials on the web, worth learning since it would give you the results you're after (and lots of other variations) without you having to do manual formulas.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon 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!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. monthly data summary sheet
    By javed65 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2012, 10:54 AM
  2. monthly data summary sheet
    By javed65 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2012, 07:08 AM
  3. Replies: 2
    Last Post: 10-11-2012, 04:50 AM
  4. Summary of the expenses
    By slashdot in forum Excel General
    Replies: 6
    Last Post: 02-08-2012, 10:42 AM
  5. Replies: 2
    Last Post: 06-17-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1