Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

total a range of cells in Excel into a different worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joint Council - 18 Nov 2005 21:17 GMT
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 to this Message
Barb Reinhardt - 18 Nov 2005 21:22 GMT
=SUM(Sheet1!A1:E1)  ???

> 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 to this Message
Joint Council - 21 Nov 2005 16:15 GMT
Dear Ms. Reinhardt:

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

> =SUM(Sheet1!A1:E1)  ???
>
> > 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 to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.