It's not a range -- no matter what terms they use.

How am I mistaken?

I never wrote that excel can not use a reference like: =sum(sheet1:sheet3!a1:a5)

I wrote that your UDF will be more irritating to write. Are you saying you have
a nice way to write your function?

If you do, then share it.


On 12/27/2010 18:13, joeu2004 wrote:
On Dec 27, 9:51 am, Dave wrote:
A range belongs to a single sheet -- excel doesn't have 3D ranges.

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

On Dec 27, 2:05 pm, Dave 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__
[...]."

--
Dave Peterson