I have data in [a1:a10] = {1,2,3,4,5,6,7,8,9,10}
I want to sum col A is result
I want result sum =10
Then in b1 =A1+A2+A3+A4
Because [A1:A4]= 1+2+3+4 =10
In b2 =A1+A9(1+9)
b3 =A2+A8(2+8)
....etc A1+A4+A5
A10
So multi range to sum to result =10
Is posibel to sum is so many cell to add to sum
Help me every body