Formula Too Long

Hello

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

='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+'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+'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Frank\[Frank''s Enforcement Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Carole\[Carole''s Enforcement Stats.xls]Enforcement Stats 2005'!F15 'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Angie\[Angie''s Enforcement Stats.xls]En

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

Thanks,
Mike

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.

"blacktour" wrote:

>
> Hello
>
> I am adding cells from different workbooks that are on a network drive
> and thier location cannot be changed. This formula is too long part of
> the location never changes how would i shorten this:
>
> ='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+'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+'S:\Corporate Services\Financial
> Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
> Revenue, Cost and Activity Monitoring\Frank\[Frank''s Enforcement
> Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial
> Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
> Revenue, Cost and Activity Monitoring\Carole\[Carole''s Enforcement
> Stats.xls]Enforcement Stats 2005'!F15 'S:\Corporate Services\Financial
> Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
> Revenue, Cost and Activity Monitoring\Angie\[Angie''s Enforcement
> Stats.xls]En
>
> The constant is
> 'S:\Corporate Services\Financial Services\Revenue\Accounts
> Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and
> Activity Monitoring\
>
> Thanks,
> Mike
>
>
> --
> blacktour
> ------------------------------------------------------------------------
> blacktour's Profile: http://www.excelforum.com/member.php...o&userid=25368
> View this thread: http://www.excelforum.com/showthread...hreadid=398611
>
>