View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Totaling cells from separate worksheets to master form

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
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