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) |