Excel formula

[ashliiii]

Suppose I have an Excel sheet with cell A1 = 1000, A2 = 950, A3 = 775, A4 = 625, A5 = 595 and A6 = 410.

If cell A5 = 2, what formula should I type in cell A6, so that A6 = 1950 which is the sum A1 + A2. If I were to type value 3 in cell A5, then cell A6 = 2725, the value A1 + A2 + A3. Thank you for your time.

 

[Kerryx]

What happens to the 595 already in A5 and the 410 in A6??

 

[Kerryx]

Book1
	A	B
1	1000
2	950
3	775
4	625
5	595	3
6	410	2725
Sheet1

Cell Formulas
Range	Formula
B6	B6	=SUM(A1:INDEX(A1:A6,B5,1))