# Formula to add incremental values

#### SONART

##### New Member
Hi All!

Hope everyone had a great festive season and a Happy New Year!

I'm having trouble putting together a formula to perform the following below:

1. I had to calculate the number of months between the dates in cell A1 which is the latest actual data (01/12/13) and cell A2 which is the projected date (01/12/14). In this example A2 - A1 = 12 months. This will change based on the current or latest data I receive on a monthly basis.

2. I then created a drop down list with the following values: 6, 12 and 18. If I select 6 as an example it will list the values 1 - 6 (see below).

List of values within each cell
A4 1
A5 2
A6 3
A7 4
A8 5
A9 6

If I select 12, it will list down the values from 1 to 12.
If I select 18, it will list down the values from 1 to 18.

Problem: I would like to add 12 (derived from point 1) on the list of values (derived from point 2). Therefore as shown below, if I select 6 it will list values 1 to 6 and then add from the list 12, resulting into 1 - 18 (see below).

List of values within the cells
A4 1
A5 2
A6 3
A7 4
A8 5
A9 6
A10 7
A11 8
A12 9
A13 10
A14 11
A15 12
A16 13
A17 14
A18 15
A19 16
A20 17
A21 18

If I select 12, it will list down values 1 to 24 (12 + 12).
If I select 18, it will list down values 1 to 30 (18 + 12).

I hope this makes sense and any assistance would be much appreciated.

SONART

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
SONART,

Try....

Excel 2007
A
101/12/2013
201/12/2014
36
41
52
63
74
85
96
107
118
129
1310
1411
1512
1613
1714
1815
1916
2017
2118
Sheet1
Cell Formulas
RangeFormula
A4=IF(ROWS(A\$4:A4)<=\$A\$3+DATEDIF(\$A\$1,\$A\$2,"m"),ROWS(A\$4:A4),"")

Hope that helps.

Many thanks SNAKEHIPS, much appreciated! It appears to be working perfectly!

Replies
4
Views
174
Replies
2
Views
213
Replies
6
Views
149
Replies
5
Views
118
Replies
3
Views
362

1,196,277
Messages
6,014,415
Members
441,818
Latest member
itsfaisalkhalid

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