Is there a multiple sheet totaling formula for XL 2003?

G

Guest

I have made a spread sheet with my weekly totals. Is there a formula that
will take the total off of my weekly spread sheet onto my monthly spread
sheet so that I can add all of my weekly totals together on a seperate,
monthly summary, spread sheet? Or do I have to transfer those numbers
manually?
 
B

Bob Phillips

=SUM(Sheet1:Sheet3!A1)

--
---
HTH

Bob

(change the xxxx to gmail 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

Urgent assistance required for excel 2
Is there a Formula that would help me? 3
multiple formula editing 2
Complicated Count if and sumif help **Big Question!!! 1
Copying Excel Sheet for data that is reliant on an equation 2
Totaling data from multiple workbooks. 1
Formula for selecting a varying cell reference 2
Excel 2007 - Linking 1

Top