how to extract data from a cell in a formula in another cell

G

Guest

hi there is problem
i have some bata in sheet1 from a1 to a240
i want the the sum of a range of these values in the cell b2 of sheet2. but
the start and end of the range i specify in cells a1 n a2 of sheet2
that is if sheet2 cells
a1=2 and a2=210
then b2 of sheet2 must contain the sum of values from a2 to a210 of sheet1.
how do i formulate this sum formula where the data of one cell is a part of
the address of another cell
kindly help
thankin in advance
 

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