Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula too long error
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 "formula too long error". Is there another way for me to have running totals without getting this error? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula too long 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 "sandwich" sheets. Put this in any cell you want: =sum(start:finish!e1) You'll be able to move any sheet out of the "sandwich" if you want to play what if games. SB wrote: 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 "formula too long error". Is there another way for me to have running totals without getting this error? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula too long error
Thank you very much for your help.
"Dave Peterson" wrote: 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 "sandwich" sheets. Put this in any cell you want: =sum(start:finish!e1) You'll be able to move any sheet out of the "sandwich" if you want to play what if games. SB wrote: 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 "formula too long error". Is there another way for me to have running totals without getting this error? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
"formula too long" error message | Excel Discussion (Misc queries) |