All,

I am using the =SUM('Start:<<End'!B7) formula to sum data from 50 sheets.
I want to make this formula little dynamic. I want the '7" in the formula to
be a cell link e.g. A1 so that it sums up the field in the cells whose row is
defined by the number input in A!.

I tried using =SUM(INDIRECT("('Start:<<End'!B"&A1) but this gives errors.

Any solutions or alternatives to this method.

Thanks much,

RK