If i in a sheet have
a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on
and in
a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on

Then in another sheet
i write maybe 4
then i want a cell there have a sum from 1 to 4
In this case from a2 to e2
if I write maybe 2
The a sum from a2 to b2

Can i do this?