Adding Data Using Multiple Worksheets to Total into a Grand Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to ignore a column of numbers in Grand Total for rows 1
Multiple Grand Total Lines 1
grand totals in pivot table rows 5
I want to link totals on multiple worksheets into one total 3
Pivot Table - copy specified Grand Totals 1
Formula needed to create grand totals 1
Grand totals on another worksheet. 1
Linking Totals Across Multiple Worksheets 2

Back
Top