On Dec 27, 5:31*am, Dave Peterson 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)?