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


--
blacktour
------------------------------------------------------------------------
blacktour's Profile: http://www.excelforum.com/member.php...o&userid=25368
View this thread: http://www.excelforum.com/showthread...hreadid=398611

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

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=398611