On Sat, 2 Apr 2005 04:37:34 -0500, "Don Kline" wrote:

I've lost my copy of a function that would add up the same cell in every
other worksheet in a workbook other than the one on which I am using the
function..

Basically I have a grand total worksheet. Every other worksheet will have
values in an identical structure on which I want to get a total no matter
how many sheets are in the workbook. As I recall, it required the use of
Application.Parent.Parent to exclude the worksheet on which the function is
being used.

I need help in reproducing that function.


=SUM(Sheet10:Sheet2!C1)

In Help type in "3D" (without the quotes) and then look for the topic: "Refer
to the same cell or range on multiple sheets"


--ron