Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.