Put some numbers in Column C of your January to December sheets.

What does

=Sum(Tag_Number)

return?

Works for me!

What you have here is actually a named *formula*.

Revise your formula by clicking on "Tag_Number" in the Define Name Window.

Then click in the "Refers To" box, and hit <F2 to enter the edit mode.

Revise the formula to this:

=SUM(Jan:Dec!C:C)

Then OK out.

Now, try this in any cell:

=Tag_Number

You should get the total of values in all your Column C's, just as you got
with using:

=Sum(Tag_Number)
--

HTH,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Kevin" wrote in message
...
Dear NG:

Has anyone been able to get this 3-D Reference to work?

This is an excerpt from the Help file telling you what to do:

Name cells on more than one worksheet by using a 3-D reference
1.. On the Insert menu, point to Name, and then click Define.
2.. In the Names in workbook box, type the name.
3.. If the Refers to box contains a reference, select the equal sign (=)
and the reference and press BACKSPACE.
4.. In the Refers to box, type = (an equal sign).
5.. Click the tab for the first worksheet to be referenced.
6.. Hold down SHIFT and click the tab for the last worksheet to be
referenced.
7.. Select the cell or range of cells to be referenced.
I've followed the directions and the range (Tag_Number) IS added to the list
of "Names in workbook"
in the "Define Name" dialog box. In the refers to box is:
=January:December!$C:$C

The range however is not listed in the drop down box in the upper left
corner of the worksheets
and it does not work in formulas.

Anyone had any success with these types of ranges?

Any help you could pass along would be appreciated.

Thanks,

-Kevin