View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
unwizzed
 
Posts: n/a
Default How do I sum totals from mulitple worksheets

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.