Calculate from another sheet - special

A

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?
 
D

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.
 
T

Teethless mama

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

change the last value '4' for your desire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top