Cumulative Growth Formula

[Sundance_Kid]

Hi,

I am comparing the growth by month between the same month year on year. So for example comparing the number of Sales in January 2019 v January 2020 and working out the growth in Sales for that month. This is straight forward.

I am then trying to calculate the cumulative (cumulative may be the wrong description to use) of the growth between years as the months go on. I have a formula in for this but it seems very manual and when I drag it, I need to change the column of the first cell each time.

Is there a shorter, better formula to use for this calculation in excel.

Pic attached for reference.

Thanks

 

[DRSteele]

You need an expanding range.

Simply change the formula in the cell for Sept Cumulative Growth (C6, I guess) to freeze the column at C. So, put a dollar sign in front of each instance of the C's at the start of each range but not the rest of the columns in the ranges (e.g., $C4:C4). Then copy rightways - it will become $C4:D4 then $C4:E4 etc.

 

[Sundance_Kid]

You need an expanding range.

Simply change the formula in the cell for Sept Cumulative Growth (C6, I guess) to freeze the column at C. So, put a dollar sign in front of each instance of the C's at the start of each range but not the rest of the columns in the ranges (e.g., $C4:C4). Then copy rightways - it will become $C4:D4 then $C4:E4 etc.

Thank you My brain must not have been thinking correctly as I should have known that.

Thanks for your help

 

[DRSteele]

You're welcome. I am glad you have it working.