=SUM(Sheet1:Sheet3!A1)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"N. Spivey" <N. wrote in message
...
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?