software

I have a spreadsheet with 50 tabs. I have a sumary tab that I will like to
show running totals, however, when I try to use a formula, i am getting a
quot;formula too long errorquot;. Is there another way for me to have running totals
without getting this error?

Say your quantities are in column E of each sheet.

Add a row at the top and put this in E1:
=sum(e2:E65536)
(Use a number that will be larger than your largest list)

Then insert two new worksheets--
one at the far left of the detail sheets and one at the far right of the detail
sheets.

Call the one at the far left: Start
call the one at the far right: Finish

Then move your summary worksheet outside those two quot;sandwichquot; sheets.

Put this in any cell you want:
=sum(start:finish!e1)

You'll be able to move any sheet out of the quot;sandwichquot; if you want to play what
if games.

SB wrote:
gt;
gt; I have a spreadsheet with 50 tabs. I have a sumary tab that I will like to
gt; show running totals, however, when I try to use a formula, i am getting a
gt; quot;formula too long errorquot;. Is there another way for me to have running totals
gt; without getting this error?

--

Dave Peterson

Thank you very much for your help.

quot;Dave Petersonquot; wrote:

gt; Say your quantities are in column E of each sheet.
gt;
gt; Add a row at the top and put this in E1:
gt; =sum(e2:E65536)
gt; (Use a number that will be larger than your largest list)
gt;
gt; Then insert two new worksheets--
gt; one at the far left of the detail sheets and one at the far right of the detail
gt; sheets.
gt;
gt; Call the one at the far left: Start
gt; call the one at the far right: Finish
gt;
gt; Then move your summary worksheet outside those two quot;sandwichquot; sheets.
gt;
gt; Put this in any cell you want:
gt; =sum(start:finish!e1)
gt;
gt; You'll be able to move any sheet out of the quot;sandwichquot; if you want to play what
gt; if games.
gt;
gt; SB wrote:
gt; gt;
gt; gt; I have a spreadsheet with 50 tabs. I have a sumary tab that I will like to
gt; gt; show running totals, however, when I try to use a formula, i am getting a
gt; gt; quot;formula too long errorquot;. Is there another way for me to have running totals
gt; gt; without getting this error?
gt;
gt; --
gt;
gt; Dave Peterson
gt;