total a range of cells in Excel into a different worksheet

Joint Council · Nov 18, 2005

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?

Barb Reinhardt · Nov 18, 2005

=SUM(Sheet1!A1:E1) ???

Joint Council · Nov 21, 2005

Dear Ms. Reinhardt:

Thank you very much! I knew it was simple. I did not have the parentheses
in the right place.