Cumulative Growth Formula

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
46
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Cumulative Growth Query.PNG
    Cumulative Growth Query.PNG
    16.2 KB · Views: 5

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,379
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Sep 2, 2017
Messages
46
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Mar 31, 2015
Messages
2,379
Office Version
  1. 365
Platform
  1. Windows
You're welcome. I am glad you have it working.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,587
Messages
5,637,232
Members
416,963
Latest member
samfuge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top