| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding numbers from sheet 2 to sheet 1
Basically I have a list of names down the sheet and across the sheet by
months I have a number. Each column (month) is added and put in bottom cell for that column, ie., =sum(e3:e50) The second sheet is the same but a different list of names. I also sum these by month at the bottom. How can I change the formula for each column on sheet 1total to include the corresponding column total from sheet 2? Many thanks. -- David |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding numbers from sheet 2 to sheet 1
Hi David
Either =SUM(E3:E50)+SUM(Sheet2!E3:E50) 0r =SUM(E3:E50)+Sheet2!E51 Assuming E51 holds the sum of the values in sheet2 -- Regards Roger Govier "caseysmydog" wrote in message ... Basically I have a list of names down the sheet and across the sheet by months I have a number. Each column (month) is added and put in bottom cell for that column, ie., =sum(e3:e50) The second sheet is the same but a different list of names. I also sum these by month at the bottom. How can I change the formula for each column on sheet 1total to include the corresponding column total from sheet 2? Many thanks. -- David |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding numbers from sheet 2 to sheet 1
-- Worked like a charm....MANY THANKS David "Roger Govier" wrote: Hi David Either =SUM(E3:E50)+SUM(Sheet2!E3:E50) 0r =SUM(E3:E50)+Sheet2!E51 Assuming E51 holds the sum of the values in sheet2 -- Regards Roger Govier "caseysmydog" wrote in message ... Basically I have a list of names down the sheet and across the sheet by months I have a number. Each column (month) is added and put in bottom cell for that column, ie., =sum(e3:e50) The second sheet is the same but a different list of names. I also sum these by month at the bottom. How can I change the formula for each column on sheet 1total to include the corresponding column total from sheet 2? Many thanks. -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding new data to another sheet from the main sheet | Excel Discussion (Misc queries) | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Taking infomation in one sheet and adding it to another sheet | Excel Discussion (Misc queries) | |||
| VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links | Excel Discussion (Misc queries) | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
Linear Mode
