software

In Excel 2003 I have set up a workbook with multiple worksheets (one
worksheet per employee/week) that sums rows and columns. What I have been
trying to do is have all of the sums from all of the worksheets read on
another worksheet. I want to end up with a totals total page which I would
call 'All Employees Total' . I want the data from each employee to be added
to each other and read on the 'All Employees Total' page.

Add a sheet called First before the first employee, and one called Last
after the last employee, and then use

=SUM(First:Last!H10)

assuming H10 is your sum cell

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;unwizzedquot; gt; wrote in message
...
gt; In Excel 2003 I have set up a workbook with multiple worksheets (one
gt; worksheet per employee/week) that sums rows and columns. What I have been
gt; trying to do is have all of the sums from all of the worksheets read on
gt; another worksheet. I want to end up with a totals total page which I would
gt; call 'All Employees Total' . I want the data from each employee to be
added
gt; to each other and read on the 'All Employees Total' page.