Remember Me?

#1
April 19th 05, 08:08 PM
 Lillie Posts: n/a
Adding Data Using Multiple Worksheets to Total into a Grand Total

Good afternoon. Currently, I have created a 10 worksheet excel document.
Each worksheet belongs to a sales rep in our company. The worksheet totals
the sales that they have had first for the week total and then there
year-to-date total. My problem is that I now need to use all 10 pages to
total into a new worksheet (with grand totals) and I am having problems doing
so.

I welcome all assistance with this problem. I have been reading by Excel
study guide, however, I am still at a lost.

Thank you.

#2
April 19th 05, 08:34 PM
 Duke Carey Posts: n/a

If all the weekly and YTD totals are in the same place on each sheet, you can
use a 3D formula on the Grand Total sheet to sum them all

=SUM(Sheet1:Sheet10!A1)

"Lillie" wrote:

Good afternoon. Currently, I have created a 10 worksheet excel document.
Each worksheet belongs to a sales rep in our company. The worksheet totals
the sales that they have had first for the week total and then there
year-to-date total. My problem is that I now need to use all 10 pages to
total into a new worksheet (with grand totals) and I am having problems doing
so.

I welcome all assistance with this problem. I have been reading by Excel
study guide, however, I am still at a lost.

Thank you.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM Stephen via OfficeKB.com Excel Worksheet Functions 1 February 4th 05 08:31 PM Robert Lawrence Excel Worksheet Functions 3 January 29th 05 05:15 AM frances Charts and Charting in Excel 2 November 29th 04 08:22 PM WP Charts and Charting in Excel 1 November 28th 04 05:19 PM

All times are GMT +1. The time now is 06:25 PM.