Using the sum function in a 3 dimension environment

[Guest]

How to Use the sum function in a 3 dimension environment in Microsoft Excel?
Need a detailed description for a research paper I am doing, ASAP!!!!

 

[Bernard Liengme]

Is this what you need?
=SUM(Sheet1:Sheet3!C1)
If sheet names have spaces use =SUM('sheet x:sheet y'!C1)

 

[Guest]

You can also do this: Start w/ =Sum(
Then click the tab for the first sheet with data to be summed.
Select the cell containing the first value.
If the values to be summed are in the same relative cells on consecutive
sheets, hold SHIFT & click the tab for the last sheet involved, then press
ENTER.
OR
If the cells are in different locations on each sheet, continue clicking
individual tabs & cells 'til you get them all, then press ENTER.

BTW- you can also select ranges as well as individual cells.

Hope this is useful |:>)