Using the sum function in a 3 dimension environment

P

Paul Hargreaves

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!!!!
 
B

Bernard Liengme

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

CyberTaz

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 |:>)
 
Top