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? |
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 |
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 |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com