='Some sheet name here'!a1 + 'Some other sheet name here'!x99

Change the names of the sheets and the addresses of the cells.

Diana M wrote:

Dear to whom it may concern,

How can I add values from 2 separate worksheets. The values are all located
in different cells on both sheets.

Thank you.

"Gord Dibben" wrote:

If the totals on each worksheet are in the same cell you can set up a 3D
reference to them on one sheet.

=SUM(Sheet1:Sheet10!H34) where H34 on each sheet holds a total for a category
on that sheet.

If the cells are randomly placed on each sheet it becomes more difficult.


Gord Dibben MS Excel MVP

On Sat, 16 Dec 2006 12:43:01 -0800, BCC wrote:

I have created an Excel file with a worksheet for each month's expenses. I
would like to have a final worksheet to sum all the different categories.
How do I add cells from multiple worksheets?
Thanks!!



--

Dave Peterson