Referencing cells dynamically

U

unregistered2

Hi, I am not an experienced Excel user, and I don't know if th
following can be done. I want to write an equation in a cell tha
contains a reference to another cell, but this reference depends on th
value of a third cell. For example, I want cell A1 to be the sum of th
first N cells of column B, where N is a value that I specify in cel
A2. So in cell A1 I want to write something like =B1:B(A2), but thi
doesn't work. Any suggestions?
Thanks
 
N

Niek Otten

Look in HELP for details of the INDIRECT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
R

RagDyer

Try this:

=SUM(INDIRECT("B1:B"&A2))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


message Hi, I am not an experienced Excel user, and I don't know if the
following can be done. I want to write an equation in a cell that
contains a reference to another cell, but this reference depends on the
value of a third cell. For example, I want cell A1 to be the sum of the
first N cells of column B, where N is a value that I specify in cell
A2. So in cell A1 I want to write something like =B1:B(A2), but this
doesn't work. Any suggestions?
Thanks.
 
Top