+ Reply to Thread
Results 1 to 2 of 2

Need Formula for getting monthly total

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    hyd
    MS-Off Ver
    2003
    Posts
    5

    Need Formula for getting monthly total

    Hi,

    I am glad i got this website, i need help, Please find the attached excel sheet.

    I have, every month data like for one Year, every day in a month we will update the sales information in to excel sheets like jan, feb, march, ...December

    In the Main sheet i want total, i have bunch of data and wide range of items, can any one suggest me the idea to get monthly consumption into main sheet.

    Please let me know i you need any further information.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: Need Formula for getting monthly total

    I would suggest redesigning your sheets slightly.
    On the monthly sheets put the totals at the top in row 2.

    Then in your Main sheet put a formula to point at each total on each sheet. So in Main!C7 the formula would be =+Jan!B2

    put the equivalent formula in each cell in your table.

    There are other ways of doing this dynamically but this is the simplest way to get the results you are asking for.
    Click * below if this answer helped

+ 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. Vlookup and Formula needed to calculate total cost by monthly basis
    By watson853 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 09:31 PM
  2. Replies: 1
    Last Post: 08-15-2013, 02:15 PM
  3. Replies: 1
    Last Post: 03-08-2013, 04:18 PM
  4. Replies: 5
    Last Post: 03-07-2013, 11:38 AM
  5. Replies: 1
    Last Post: 01-02-2012, 10:12 AM

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