Selecting across worksheets

G

Guest

How do I select across worksheets within a file?

I want to select across worksheets and view the accumulating total at the
bottom of the worksheet.
 
B

Bob Phillips

=SUM(Sheet1!:Sheet3!A3)

--

HTH

RP
(remove nothere from the 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

Selecting and summing across worksheets 2
Selecting and viewing sum in status bar across worksheets 2
getting a sum across multiple worksheets, then adding the numbers together 2
Conditional Formatting Across Spreadsheets 3
Matching records based on a common field 1
Auto fill across multiple worksheets 3
Ranking across worksheets 3
copying & incrementing formulae across open worksheets 4

Top