View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Bob Phillips
 
Posts: n/a
Default How do I run sums from one worksheet to another?

=SUM(Sheet1:Sheet12!A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mike Holliday" <Mike wrote in message
...
At one time I knew how to do this, but it has been 3 or so years and I do

not
remember how. I have a workbook with 13 worksheets, the final sheet has
totals from the first 12 pages that I wish to put on the final worksheet.
Thank you.

Mike Holliday