Sum data in multiple cells from two worksheets

[ccwies]

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?

 

[T. Valko]

page 16

page 17

Are those your actual sheet names?

Try this:

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

 

[xlmate]

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.