Take a look at this screencap:

http://img210.imageshack.us/img210/8144/sumgg1.jpg

The formula is on the Summary sheet. The Summary sheet is outside of the
"sandwich". Any sheets *within* the sandwich will be included in the sum.

--
Biff
Microsoft Excel MVP


"ABG" wrote in message
...
i must be slow at excel...but i've been trying to do this and keep getting
these weird errors.
helppppp............ughhhhhhhhhhhhhhhhh.....frustr ation....

"Dave Peterson" wrote:

I like to make a "sandwich" out of my worksheets.

I'd insert two worksheets--one to the far left called "Start" and one to
the far
right named "End".

Then I could use a formula like:

=sum('start:end'!N2)
to add up all the worksheets that are between those two "pieces of
bread".

The cell with the formula would go in a worksheet that's not inside the
sandwich.

ABG wrote:

Hello to all who can help me with this. I've already tried the online
directions and it's still not working.

Ex/
I have 3 worksheets and 1 final all within the same excel 2003 file. I
am
trying to get all the cells from worksheets 1,2,& 3 to add up and be
placed
in worksheet 4. I know that their is a way to do this but I must not
be
doing it correctly. Could someone please give me some insider
direction I
would appreciate it.

Thanks,

--

Dave Peterson