Calculate from another sheet - special

[alvin Kuiper]

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?

 

[David Biddulph]

If 4 is A2 to E2, and 2 is A2 to B2, presumably 3 is A2 to about half way
between C2 and D2?

It sounds as if you want the OFFSET function; details in Excel help.

 

[Teethless mama]

=SUM(Sheet1!A2:INDEX(Sheet1!2:2,4))

change the last value '4' for your desire