Use this
=SUM(Sheet1!F162:INDIRECT("Sheet1!F" &B2))
See also
http://www.cpearson.com/excel/indirect.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Paul T" wrote in message ...
I am trying to write a formula that, based on a cell on the current sheet,
references a cell from another sheet. I am getting a #NAME? error and I
cannot figure out how to correct it.
Example: =SUM(Sheet1!F162:Sheet1!F(B2))*Sheet1!E233
The B2 cell is supposed to determine which Sheet1 cell to use. I am using
Excel version 2000 9.0.7616 SP-3. Any suggestions would be greatly
appreciated.