| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding one cell in Sheet 1 to another cell in Sheet 2
How can I add cells across multiple sheets? I need to add A3 (Sheet 1) to A6
(Sheet 2) and have the total appear in A31 (Sheet 1). Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding one cell in Sheet 1 to another cell in Sheet 2
=(a3+Sheet2!a6)
-- regards from Brazil Thanks in advance for your feedback. Marcelo "Web Office Support" escreveu: How can I add cells across multiple sheets? I need to add A3 (Sheet 1) to A6 (Sheet 2) and have the total appear in A31 (Sheet 1). Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding one cell in Sheet 1 to another cell in Sheet 2
Thank you very much, Marcelo! I appreciate your help!
"Marcelo" wrote: =(a3+Sheet2!a6) -- regards from Brazil Thanks in advance for your feedback. Marcelo "Web Office Support" escreveu: How can I add cells across multiple sheets? I need to add A3 (Sheet 1) to A6 (Sheet 2) and have the total appear in A31 (Sheet 1). Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Cell Value to another Sheet if... | Excel Discussion (Misc queries) | |||
| Adding in a cell from one sheet to another | Excel Worksheet Functions | |||
| Excel, adding figures from one cell to a summary sheet or workbook | Excel Discussion (Misc queries) | |||
| Adding comments to unprotected cell in a protected sheet | Excel Discussion (Misc queries) | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
Linear Mode
