Yes. That's what I'm saying.

A range belongs to a single sheet -- excel doesn't have 3D ranges.



On 12/27/2010 08:15, joeu2004 wrote:
On Dec 27, 5:31 am, Dave wrote:
Take a look at what you'll need to do at John Walkenbach's old site:
http://j-walk.com/ss/excel/eee/eee003.txt
and look for SumProduct3D, SumIf3D, CountIf3D

As I understand that, that requires that we call mySUM("Sheet1:Sheet3!
A1"). Right?

Are you implying that we cannot call mySUM(Sheet1:Sheet3!A1) per se (a
3D range, not a string)?

--
Dave Peterson