Formula too long

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have an extremely long formula that sums the totals from
13 different worksheets saved in a different folder. When
I try to edit the formual I get an error that says formula
too long. Is there a way to increase the amount of
information within a formula because in the future I am
going to need to add more parts to this formula and it is
already too long. Thanks for the help.

Todd
 
Please explain a little more if you will. I am
realatively new to writing macros. How can I write a
macro that will take values from different worksheets and
sum them in a particular cell in another worksheet?
 
The formula is a basic sum function that says take cell A1
from G:\Operations\Application Processing\2003
reports\Individual Log\B E.xls and sum with the exact same
formula but differnt .xls file. The problem is the
length of the path to get to the cell but it has to be
that way. Any help is appreciated.
 
Todd,

Personally I would use a summary column, hidden if necessary, where the values from the source sheets are entered into separate cells. Then just sum the column.
That way the formula length is not a problem, and the result will be easier to verify.

Just a thought,
Anders Silven
 
Back
Top