ExcelBanter - Is there a multiple sheet totaling formula for XL 2003?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there a multiple sheet totaling formula for XL 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/121564-there-multiple-sheet-totaling-formula-xl-2003-a.html)

N. Spivey

Is there a multiple sheet totaling formula for XL 2003?

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?

Bob Phillips

Is there a multiple sheet totaling formula for XL 2003?

=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?

All times are GMT +1. The time now is 09:18 AM.