| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total a range of cells in Excel into a different worksheet
In Excel 2002, what is the formula to sum a range of cells in worksheet 1 and
display the total in a cell in worksheet 2? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
total a range of cells in Excel into a different worksheet
=SUM(Sheet1!A1:E1) ???
"Joint Council" <Joint wrote in message ... In Excel 2002, what is the formula to sum a range of cells in worksheet 1 and display the total in a cell in worksheet 2? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
total a range of cells in Excel into a different worksheet
Dear Ms. Reinhardt:
Thank you very much! I knew it was simple. I did not have the parentheses in the right place. "Barb Reinhardt" wrote: =SUM(Sheet1!A1:E1) ??? "Joint Council" <Joint wrote in message ... In Excel 2002, what is the formula to sum a range of cells in worksheet 1 and display the total in a cell in worksheet 2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
| In Excel 2000, Cannot edit cells in worksheet created in 2003? | Excel Discussion (Misc queries) | |||
| embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
| is there a way to protect a range of cells on a worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
