Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |||
Display names | Excel Discussion (Misc queries) | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |