| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error: The text string you entered is too long.
Can someone help me shorten this formula, without having to change the
path location of the linked sheet in the formula or without having to use additional cells in either sheet to do the calculation? The result of the formula only shows up if I have the linked spreadsheet open because it will shorten "('C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!" to just "[Name of spreadsheet ''06.xls]Spreadsheet'!" Which shortens the formula enough to not use up the max amount of characters, I'm thinking there might be an easier way to calculate the math in the formula to shorten it, or a way to not display the whole path of the file. =SUM(SUMIF('C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$A$5:$A$35,"<="&LOOKUP(TODAY(),KC!B31 :E31),'C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$D$5:$D$35)-SUMIF('C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$A$5:$A$35,"<="&LOOKUP(TODAY()-7,KC!B31:E31),'C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$D$5:$D$35))/(SUMIF('C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$A$5:$A$35,"<="&LOOKUP(TODAY(),KC!B31 :E31),'C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$C$5:$C$35)-SUMIF('C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$A$5:$A$35,"<="&LOOKUP(TODAY()-7,KC!B31:E31),'C:\Open folder\Dummy folder\Default\Sub Folder\Another Folder\2nd to last folder\last folder "06\[Name of spreadsheet ''06.xls]Spreadsheet'!$C$5:$C$35)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| macro to run series of reports to PDF | Excel Worksheet Functions | |||
| Find nth instance of a character in a string | Excel Discussion (Misc queries) | |||
Threaded Mode
