**Question description:**

*This user has given permission to use the problem statement for this blog.*

i have a cell which displays a number, i would like the following sell to automatically change the second variable in the Sum(A1:A2) (A2) to the cell which displays the number

Solved by A. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
14/08/2018 - 07:38

how would i get that to change by itself

User
14/08/2018 - 07:38

rather than me having to manually input 56

Excelchat Expert
14/08/2018 - 07:39

hello welcome to got it

Excelchat Expert
14/08/2018 - 07:39

let me see if I understand your problem correctly

User
14/08/2018 - 07:40

ok

Excelchat Expert
14/08/2018 - 07:40

So you have a sum formula in c2

User
14/08/2018 - 07:40

yes

Excelchat Expert
14/08/2018 - 07:40

a1:a56

Excelchat Expert
14/08/2018 - 07:40

you want it to say a1:a750

Excelchat Expert
14/08/2018 - 07:40

depending on cell e2

User
14/08/2018 - 07:40

that is what i would like

Excelchat Expert
14/08/2018 - 07:41

ok it is possible

User
14/08/2018 - 07:41

so when E2 changes the second variable in C2 would change to that number of cells

User
14/08/2018 - 07:41

based on column A

Excelchat Expert
14/08/2018 - 07:42

ok

Excelchat Expert
14/08/2018 - 07:42

give me a couple of mins

Excelchat Expert
14/08/2018 - 07:51

sorry for the delay

Excelchat Expert
14/08/2018 - 07:52

i believe cell c6 is what you are looking for

Excelchat Expert
14/08/2018 - 07:52

are you still there please?

Excelchat Expert
14/08/2018 - 07:56

this the formula solution for your problem: =sum(A1:INDIRECT("a" & E2))

Excelchat Expert
14/08/2018 - 07:56

good day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*