| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for totals throughout sheet | Excel Discussion (Misc queries) | |||
| Making a totals Sheet | Excel Discussion (Misc queries) | |||
| Sheet to Sheet Totals | Excel Discussion (Misc queries) | |||
| How to add totals in one sheet to another sheet | Excel Discussion (Misc queries) | |||
| Summary Sheet Totals | Excel Discussion (Misc queries) | |||
Threaded Mode
