| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totaling cells from separate worksheets to master form
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totaling cells in multiple worksheets | Excel Worksheet Functions | |||
| Break master list up into lists in separate worksheets | Excel Discussion (Misc queries) | |||
| How do I print two separate cells in a certain space on a form | Excel Discussion (Misc queries) | |||
| Totaling cells from p.c. worksheets to a cell on a server workshee | Excel Discussion (Misc queries) | |||
| Totaling Cells in Worksheets | Excel Worksheet Functions | |||
Linear Mode
