viman
Newbie
Joined: 28 May 2012
Posts: 1
|
 Posted: Mon May 28, 2012 3:12 am Post subject: vlookup countif and sumif across files problem |
 |
|
Hi All
I 'm using a libreoffice version 3.34 with the Java 1.6.25. I have encountered a problem relating the vlookup, countif and sumif functions across the file.
When I wrote the vlookup formula across file, it's very smooth for only first time. After it has been save, then it does not work(sheet name does not appear) . However, the countif and sumif does not work for all cases as the follows:
First time (work)
| Code: | | '=VLOOKUP(A3,'file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$Group_Model.A2:B10,2,0) |
Result -- work
| Code: | | '=COUNTIF('file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$Group_Model.A2:A10,A3) |
Result -- Error 504
| Code: | | '=SUMIF('file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$Group_Model.A2:A10 |
Result = Error504
After save files, open it again (All does not work)
| Code: | | '=VLOOKUP(A3,'file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$''.A2:B10,2,0) |
Result -- Error 502
| Code: | | '=COUNTIF('file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$''.A2:A10,A3) |
Result -- Error:504
| Code: | | '=SUMIF('file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$''.A2:A10,A3,'file:///C:/Users/tacherdc/Desktop/Test/Table_Lookup.xls'#$''.B2:B10) |
Result -- Error 504
Your help will be appreciated.
Thanks
Niti : )
[/code][/quote] |
|
