# Sum values of future months

1. ## 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!

2. ## 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!

3. ## 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. ## 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"

5. ## 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!!

7. ## Re: Sum values of future months

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

#### 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