Hi all! I wish to sum from particular cell to last cell in a single row. Example:
I have a row A with values = [1 5 7 1 3 4 5 12 2 4]
And I want to sum cell 2 to last cell, cell 6 to last cell, and cell 9 to last cell.
I wish to have something like for loop with customize value so I can get the value of:
cell 2 to last cell = [5+7+1+3+4+5+12+4] = 41
cell 6 to last cell = [4+5+12+2+4] = 27
cell 9 to last cell = [2+4] = 6
I tried to use something like i=length(A):10, but it doesn't and I don't think it is correct as well.
Thanks for the help and I really appreciate it!