Dynamic sum range based on cell value input

[leebauman]

I need to sum a range of cells and I need the range to be controlled by an input in a cell outside the range. For example:

Book1
	H	I	J
1	Days	3
2
3	Day	Qty	Future Total Qty
4	1	4	12
5	2	2	12
6	3	6	11
7	4	4	14
8	5	1	14
9	6	9	13
10	7	4	5
11	8	0	6
12	9	1
13	10	5
Sheet1

Cell Formulas
Range	Formula
J4:J11	J4	=SUM(I4:I6)

Or, if I change the input to "4", then the range changes to a set of 4 cells:

Book1
	H	I	J
1	Days	4
2
3	Day	Qty	Future Total Qty
4	1	4	16
5	2	2	13
6	3	6	20
7	4	4	18
8	5	1	14
9	6	9	14
10	7	4	10
11	8	0
12	9	1
13	10	5
Sheet1

Cell Formulas
Range	Formula
J4:J10	J4	=SUM(I4:I7)

Is this possible? Thank you.

 

[Coyotex3]

Is this what you are looking for?

=SUM(TAKE(I4:I13,$I$1))

 

[leebauman]

That works perfectly. I appreciate it!

 

[Coyotex3]

Happy to help!