Formula too long

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
 
T

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?
 
T

Todd

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.
 
A

Anders S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top