I renamed the sheets to sheet 1 and so on. Works great.
Thanks

--
----------------------------------------------------
This mailbox protected from unsolicited email by Spam Alarm
from Dignity Software http://www.dignitysoftware.com
"Pete_UK" wrote in message
ups.com...
The syntax is essentially first_sheet:last_sheet, so you could make it
Main:Cheer if these are the outer sheets of the range of sheets to
want to add from - ensure that the main sheet is to the left or right
(i.e. outside of the range of sheets in your file).

Hope this helps.

Pete

On Jul 31, 11:50 pm, "Doug" wrote:
Each sheet is named, Main, Flag, Midgets, Rookies, Juniors, Seniors and
Cheer. I want their totals on the Main sheet. I am tracking my youth
football teams fundraising. Should I rename them back to sheet 1,2,
etc..........

--
----------------------------------------------------
This mailbox protected from unsolicited email by Spam Alarm
from Dignity Software http://www.dignitysoftware.com"Teethless mama"
wrote in message

...



=SUM(Sheet1:Sheet7!A20)

"Doug" wrote:

I have a workbook with 7 sheets. Each sheet has several colums with
each
having a dollar total and quanity ordered. How do I make all the
totals
from
each sheet total up on the last sheet for a grand total? I need to
know
how
many dollars were spent and how many of each product was ordered.

Doug

--
----------------------------------------------------
This mailbox protected from unsolicited email by Spam Alarm
from Dignity Software http://www.dignitysoftware.com- Hide quoted
text -

- Show quoted text -