Prev: How to total a column of cells without using Autosum
Next: Sort by column, not range
From: snake941 on 21 Apr 2010 17:31
If I have 2 separate worksheets with individual cell values and want the
total to show the sum of obth cells, how do I do it?

Nelson
From: Pete_UK on 21 Apr 2010 20:13
Suppose those values are in F10 on one sheet and in G6 of the other
sheet, then put this in the appropriate cell of your master sheet:

=Sheet1!F10 + Sheet2!G6

to add them both together.

If your actual sheet names contain spaces you will need to include
apostophes around the sheet name, like:

='First Sheet'!F10 + 'Second Sheet'!G6

Hope this helps.

Pete

On Apr 21, 10:31 pm, snake941 <snake...(a)discussions.microsoft.com>
wrote:
> If I have 2 separate worksheets with individual cell values and want the
> total to show the sum of obth cells, how do I do it?
>
> Nelson

 | 
Pages: 1
Prev: How to total a column of cells without using Autosum
Next: Sort by column, not range