Hi there (first post, please be lenient),

In every sheet (Sheet1, Sheet2, Sheet3) I have one value in cell B2. I add these B2's like this:
=SUM(Sheet1:Sheet3!B2)
Now, the names of the Sheets can vary and sometimes I only want to sum from Sheet1 to Sheet2.

Therefore I write in cell A1 the name of the first sheet where I want to start summing and in A2 the name of the last sheet. Like this:
A1 = "Sheet1"
A2= "Sheet3"
Now I try to sum again using indirect formula:
=SUM(INDIRECT(A1&":"&A2&"!B2"))  ----> now I get #REF
Can anybody tell me where's my mistake? Thank you so much!