Summing Monthly Numbers with Increases after Specified Intervals
I am trying to project out monthly amounts, with the amounts for each individual month able to increase by a certain amount after a certain number of months.
I can do this with a waterfall (Line 20 of the attachment) but, given the size of the model, Iíd like to avoid that.
I am not super-knowledgeable with this stuff, but I can get close by using a sumproduct (Line 23). But itís not exactly correct because for each individual month, the number of months thereafter that triggers the increase starts counting from the very first month instead of the month which contains the original amount. I hope that makes sense.
Any help would be appreciated!
Re: Summing Monthly Numbers with Increases after Specified Intervals
Duplicate thread closed. Please continue in the original thread here: https://www.excelforum.com/excel-for...increases.html
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By excel-help in forum Excel Formulas & Functions
Last Post: 07-26-2017, 08:28 PM
By bhenlee in forum Excel Formulas & Functions
Last Post: 05-16-2016, 11:18 AM
By Jbelle7435 in forum Excel General
Last Post: 09-16-2014, 01:41 PM
By auswtz in forum Excel Formulas & Functions
Last Post: 03-24-2013, 11:09 PM
By myoon in forum Excel General
Last Post: 08-02-2011, 03:12 PM
By miami580 in forum Excel General
Last Post: 08-05-2010, 11:45 AM
By SteveC in forum Excel General
Last Post: 06-14-2006, 08:10 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1