On Dec 27, 9:51 am, Dave Peterson wrote:
A range belongs to a single sheet -- excel doesn't have 3D ranges.

On Dec 27, 1:27 pm, joeu2004 wrote:
SUM(Sheet1:Sheet3!A1) does work in XL2003 and later

On Dec 27, 2:05*pm, Dave Peterson wrote:
If you had called it a reference, not a range, I'd have no problem.

SUM(Sheet1:Sheet3!A1:C1) works in XL2003 and later, as well.

And your buddies at http://j-walk.com/ss/excel/eee/eee003.txt call at
least that a "3D range"[*].

So whether you thought I was talking about "3D reference" or "3D
range", you still seem to be mistaken.

-----
Endnotes
[*] From http://j-walk.com/ss/excel/eee/eee003.txt (emphasis added):

"Excel allows you to make 3D formulas based on the following syntax:
Sheet1:Sheet4!A2:B5
[....]
BTW, If you create a defined name for this type of __3D_range__
[...]."