Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
long formula obscures cell view | Excel Discussion (Misc queries) | |||
Formula too long | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |