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.

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.