Formula Too Long

[blacktour]

Hello

I am adding cells from different workbooks that are on a network driv
and thier location cannot be changed. This formula is too long part o
the location never changes how would i shorten this:

='S:\Corporate Services\Financial Services\Revenue\Account
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost an
Activity Monitoring\Stephan\[Stephan''s Enforcemen
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financia
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\
Revenue, Cost and Activity Monitoring\Mike\[Mike''s Enforcemen
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financia
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\
Revenue, Cost and Activity Monitoring\Frank\[Frank''s Enforcemen
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financia
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\
Revenue, Cost and Activity Monitoring\Carole\[Carole''s Enforcemen
Stats.xls]Enforcement Stats 2005'!F15 'S:\Corporate Services\Financia
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\
Revenue, Cost and Activity Monitoring\Angie\[Angie''s Enforcemen
Stats.xls]En

The constant is
'S:\Corporate Services\Financial Services\Revenue\Account
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost an
Activity Monitoring\

Thanks,
Mik

 

[Guest]

Instead of doing the sum all in one cell, bring all the information onto one
sheet in individual cells and then add it up in the sheet. This way it is
also easier to understand what is added together and what the underlying
numbers are.

 

[swatsp0p]

I would create a new sheet in my summary workbook and store in separate
cells each value, as such:

in A1: ='S:\Corporate Services\Financial Services\Revenue\Accounts
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and
Activity Monitoring\Stephan\[Stephan''s Enforcement
Stats.xls]Enforcement Stats 2005'!F15

In A2: ='S:\Corporate Services\Financial Services\Revenue\Accounts
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and
Activity Monitoring\Mike\[Mike''s Enforcement Stats.xls]Enforcement
Stats 2005'!F15

...and so on, then =SUM(Sheet2!A1:A??)

HTH