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.