To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 Issue #|97711 Summary|sumif criterion differs from cell formula Component|Spreadsheet Version|OOO300m9 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|ztevepowell
------- Additional comments from ztevepow...@openoffice.org Fri Jan 2 20:05:45 +0000 2009 ------- sumif(a1:a3;"<>y";b1:b3) produces 10 for the following input: A1 : <empty> A2 : n A3 : y B1 : 1 B2 : 10 B3 : 100 but the cells making individual tests are as follows: C1 : A1<>"y" displays TRUE C2 : A2<>"y" displays TRUE C3 : A3<>"y" displays FALSE we should get the answer '11' from the SUMIF formula, if the criteria behave the same, which they should. The treatment of <empty> cells is different, and this makes it hard to programme some SUMIF statements (this is different from the XL behaviour in this case, too). --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org