How do I run sums from one worksheet to another?

M

Mike Holliday

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
(e-mail address removed)
 
B

Bob Phillips

=SUM(Sheet1:Sheet12!A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

VBA to do a mailmerge from a Specific Excel worksheet 0
Using VBA to copy data into another worksheet ??? 2
New computer, how do i move outlook 365 ENTIRELY? 0
populate new "log" worksheet from invoice templates in other sheets 0
Paragraph numbering in Word 1
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data from linked worksheet back to a master worksheet? 0

Top