To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46681 Issue #:|46681 Summary:|SUM/IF array formula gives wrong result Component:|Spreadsheet Version:|680m87 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|er Reported by:|dr
------- Additional comments from [EMAIL PROTECTED] Tue Apr 5 01:44:33 -0700 2005 ------- Following test case: A1: 1 B1: 1 C1: 2 A2: 2 B2: 1 C2: 2 A3: =SUM(IF(A1:A2<2;B1:C2;0)) Result is 1 (B1 only), but should be 3 (sum of B1:C1). --------------------------------------------------------------------- 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]
