To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73384 Issue #|73384 Summary|SUMIF can't match on empty cells Component|Spreadsheet Version|OOo 2.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|mhanauska
------- Additional comments from [EMAIL PROTECTED] Thu Jan 11 07:55:33 -0800 2007 ------- The following works fine =SUMIF(A1:A7;"<>";B1:B7) It gets me the sum of all fields in row B that have non empty values in row A. Perfect. But the following gets me zero as result =SUMIF(A1:A7;"";B1:B7) And that is not true, there is a field, A5, it is empty, but B5 is 50 so the result should be 50, but it's not. In Excel, this works! Might be that "" is wrong to match empty cells, in that case, please tell me how to do it. --------------------------------------------------------------------- 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]
