Sum data in multiple cells from two worksheets
 

I have been unsuccessful at attempting to sum data in two worksheets
(multiple cells). I have tried using the 3-D reference but apparently I am
not understanding the process.

I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into cell
F48 on page 17. Can someone give me step by step instructions starting with
what is expected as a name in the "Names in workbook" in the 3-D reference
function (if this is the how I need to get my desired result?

Sum data in multiple cells from two worksheets
 

page 16
page 17

Are those your actual sheet names?

Try this:

=SUM('page 16'!F6:F53,F6:F47)

--
Biff
Microsoft Excel MVP


"ccwies" wrote in message
...
I have been unsuccessful at attempting to sum data in two worksheets
(multiple cells). I have tried using the 3-D reference but apparently I
am
not understanding the process.

I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into
cell
F48 on page 17. Can someone give me step by step instructions starting
with
what is expected as a name in the "Names in workbook" in the 3-D reference
function (if this is the how I need to get my desired result?

Sum data in multiple cells from two worksheets
 

Hi ccwies

If you just want to sum the ranges in different sheets, try this

In Cell F48 of Sheet17, place this formula

=SUM(Sheet16!F6:F53,Sheet17!F6:F47)

Does this do waht you want?

=======================
Pls click Yes if this has help you

Thank You

cheers, Francis


I may be able to provide you a solution, there would be better solutions
from others.



"ccwies" wrote:

I have been unsuccessful at attempting to sum data in two worksheets
(multiple cells). I have tried using the 3-D reference but apparently I am
not understanding the process.

I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into cell
F48 on page 17. Can someone give me step by step instructions starting with
what is expected as a name in the "Names in workbook" in the 3-D reference
function (if this is the how I need to get my desired result?