View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Totals from sheet to sheet

Select cell A1 in Sheet3, and enter an equal sign, now use the mouse to
select Sheet1 - cell A1. Enter a plus sign and select cell A1 in sheet2.
Press enter

The formula in sheet3 should look like:

=Sheet1!A1+Sheet2!A1

Hopes this helps

Per

"Skydiver" skrev i meddelelsen
...
I'd like to total some figures in sheet 3 from sheets 1 & 2. Help!