# Cumulative Growth Formula

#### Sundance_Kid

##### New Member
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
16.2 KB · Views: 5

### Excel Facts

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

#### DRSteele

##### Well-known Member
You're welcome. I am glad you have it working.

Replies
0
Views
51
Replies
7
Views
269
Replies
6
Views
236
Replies
0
Views
105
Replies
6
Views
86

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.

### Which adblocker are you using?

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

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