like your analogy...ok so if the end of the sandwich i have my "plate" to put
it on where to i put the =sum....

"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