sum automatically between chosen worksheets

If I understand what you are trying to do, sum all the A1 cells in 31 sheets.

Try: =SUM(Sheet1:Sheet31!A1)

Originally Posted by alansidman

If I understand what you are trying to do, sum all the A1 cells in 31 sheets.

Try: =SUM(Sheet1:Sheet31!A1)

I guessing he wants a dynamic 3D formula, which forces you to use INDIRECT. But this formula will give you an #REF if you write it like this:

=SUM(INDIRECT("'"&A1&":"&B1&"'!A1"))

You will need an array similar to mines if you want to accomplish what he wants. Sum from the sheet number he inputs in A1 to the sheet number he enters in B2.