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.