+ Reply to Thread
Results 1 to 4 of 4

How to automatically tabulate month end figures.

  1. #1
    Registered User
    Join Date
    12-04-2007
    Posts
    1

    How to automatically tabulate month end figures.

    At the end of each month, we print out a summary of significant data such as gross income, number of customers served, average cost per transaction, etc.

    I have a printout for each month of the year but I want to get the numbers compiled on a single spread sheet so I can see trends and potential issues.

    There must be a way to ask Excel to do this automatically without having to manually reenter all the numbers into a single spreadsheet. But how?

    Any help is appreciated.

    Kim Nicholas

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    6,997
    Can you post a file?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325
    Welcome to the board

    you can find solutions at http://www.rondebruin.nl/tips.htm

    HTH

  4. #4
    Registered User
    Join Date
    12-06-2007
    Posts
    7
    To add numbers up in multiple sheets right?
    create a sheet, name it monthly totals...? Then in a cell type =sum(
    Then click on another sheet in the cell you want to add, then click the + sign and open another sheet and click on the cell you want to add.....and so forth and once you've added them all, hit enter.
    =SUM('Ent.to B'!A11+'ENTRANCE TO C'!A11)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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