=SUM(INDIRECT(" Dynamic solution help

[Hondahawkrider]

It's easy enough to sum up values on another sheet.. if I am on Sheet1 and do the following it works great

=SUM('Sheet2'!B64:'Sheet2'!B111)

However, Sheet3 has some values I would like to incorporate, basically A1 = 64 and B1 = 111 (these cells are dynamically created and can change)

So what I am trying to do from Sheet1 is add up the sum of Sheet2 B64 thru B111 where the values of 64 is on sheet3 in A1 and 111 is on sheet3 in B1...

I should be able to use =SUM(INDIRECT I thought I should be able to reference "&sheet3!$A$1 instead of manually putting in 64 and "&sheet3!$B$1 but the whole crossing of sheets and values has me all mixed up..

Help

[Tony Valko]

INDIRECT will work but INDEX is better.

=SUM(INDEX(Sheet2!B:B,Sheet3!A1):INDEX(Sheet2!B:B,Sheet3!B1))