+ Reply to Thread
Results 1 to 7 of 7

Sum values of future months

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Sum values of future months

    Hi good people!

    I am going to try and explain what I am looking for. The attachment shows 2 rows, one with months and beneath some figures. To the left I have input fields. In column A I will put a date. In column B I will input a figure. I would like a formula in column C, that will look at the MONTH of the date in column A, then add a month, and starting from this new calculated month, add all figures in the row underneath the corresponding new month row, to the end. Also do I want the figure in column B added.

    All and any help will be greatly appreciated!. Thank you all very much!
    Attached Files Attached Files
    Last edited by juriemagic; 07-07-2017 at 10:14 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,099

    Re: Sum values of future months

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Re: Sum values of future months

    Hi AliGW,

    Sorry about this, I was actually first testing my user here at work to see if the file was going to upload, before I wasted time in trying to explain my problem...I guess on your side it may have appeared that I was only posting an attachment without any written info..Sorry about that.. :-)

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Sum values of future months

    Try


    =$B6+SUM(OFFSET($E$2,ROW()-2,MATCH(EOMONTH($A6,-1)+1,$E$2:$P$2,0),1,DATEDIF(EOMONTH($A6,-1)+1,$P$2,"m")))

    Dates in row 2 changed to Excel dates (01/04/2017 etc )formatted as "mmm"
    Attached Files Attached Files
    Last edited by JohnTopley; 07-07-2017 at 11:41 AM.

  5. #5
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Re: Sum values of future months

    JohnTopley,

    I can see why you are a Forum Expert!!!..because you simply are an Excel expert!..Thank you very very much!!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Sum values of future months

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Re: Sum values of future months

    sorry, I forgot about that..thanx!

+ 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. Forecasting across future months
    By Dave.Oz in forum Excel General
    Replies: 1
    Last Post: 04-04-2014, 11:18 AM
  2. Ignore Months In The Future
    By xybadog in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2014, 07:06 AM
  3. How to Translate Nr. of Months into a Future Date
    By BSquared18 in forum Excel General
    Replies: 9
    Last Post: 08-24-2013, 09:09 AM
  4. how do I set monthly totals, but keep future months at zero?
    By Neutrino Two in forum Excel General
    Replies: 3
    Last Post: 12-16-2011, 02:59 AM
  5. Pivot table for future none existent months
    By bg18461 in forum Excel General
    Replies: 4
    Last Post: 08-25-2006, 10:06 AM
  6. formula to remind me of an appointment 3 months in the future
    By jamaicanbashi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2006, 07:45 AM
  7. [SOLVED] Networkdays & future months
    By denise in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-01-2006, 07:35 AM

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