To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101267 Issue #|101267 Summary|sum if function Component|Spreadsheet Version|1.0.3 Platform|Unknown URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|all Reported by|vishnugolani
------- Additional comments from [email protected] Wed Apr 22 10:58:05 +0000 2009 ------- i am giving below the formula which working if msoffice2007 =SUM(SUMIFS('C:\privet\2009\[monthly20091trial.xls]JAN- 09'!$C$5:$C$19,'C:\privet\2009\[monthly20091trial.xls]JAN- 09'!$B$5:$B$19,"Oyester"),SUMIFS('C:\privet\2009\[monthly20091trial.xls]JAN- 09'!$C$5:$C$19,'C:\privet\2009\[monthly20091trial.xls]JAN- 09'!$B$5:$B$19,"Oyester Topup"),SUMIFS('C:\privet\2009\[monthly20091trial.xls]JAN- 09'!$C$5:$C$19,'C:\privet\2009\[monthly20091trial.xls]JAN-09'!$B$5:$B$19," ")) its doesn't work if open office. instead of sumif i tried following formula =SUM('file:///C:/privet/open office/monthly09.ods'#$'JAN-09'.B5:B12="*oyster*" * 'file:///C:/privet/open office/monthly09.ods'#$'JAN-09'.C5:C12) but its also not working. i am trying that in current speared sheet i fatch the value of other speared sheet. The result shows #VALUE... In detail i got three column name date, description, and amount. i want total of amount with description contains oyster. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
