| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum From multiple cells on another sheet
I have 2 sheets ,sheet 2 has a summed value in cells c19,c37,c56,c74 that i
want to sum up and be on sheet 1 cell c3 to make a final total. Thanks Karl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum From multiple cells on another sheet
Try this:
=SUM(Sheet2!C19,Sheet2!C37,Sheet2!C56,Sheet2!C74) Biff "Karl" wrote in message ... I have 2 sheets ,sheet 2 has a summed value in cells c19,c37,c56,c74 that i want to sum up and be on sheet 1 cell c3 to make a final total. Thanks Karl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum From multiple cells on another sheet
That worked great once i put the 'sheet 2'around the sheet name Thanks
"T. Valko" wrote: Try this: =SUM(Sheet2!C19,Sheet2!C37,Sheet2!C56,Sheet2!C74) Biff "Karl" wrote in message ... I have 2 sheets ,sheet 2 has a summed value in cells c19,c37,c56,c74 that i want to sum up and be on sheet 1 cell c3 to make a final total. Thanks Karl |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum From multiple cells on another sheet
You're welcome!
Biff "Karl" wrote in message ... That worked great once i put the 'sheet 2'around the sheet name Thanks "T. Valko" wrote: Try this: =SUM(Sheet2!C19,Sheet2!C37,Sheet2!C56,Sheet2!C74) Biff "Karl" wrote in message ... I have 2 sheets ,sheet 2 has a summed value in cells c19,c37,c56,c74 that i want to sum up and be on sheet 1 cell c3 to make a final total. Thanks Karl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
| Graph on each sheet when I mark same cells on multiple sheets | Excel Discussion (Misc queries) | |||
| Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Linear Mode
