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!!!!
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!!!!
Is this what you need?
=SUM(Sheet1:Sheet3!C1)
If sheet names have spaces use =SUM('sheet x:sheet y'!C1)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Paul Hargreaves" <Paul [email protected]> wrote in
message news:[email protected]...
> 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!!!!
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 |:>)
"Paul Hargreaves" wrote:
> 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!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks