Referencing cells dynamically

  • Thread starter Thread starter unregistered2
  • Start date Start date
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
 
Look in HELP for details of the INDIRECT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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.
 
Back
Top