To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54885
User er changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Resolution| |DUPLICATE -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Thu Sep 22 07:44:11 -0700 2005 ------- Received the document from the submitter. Basically this boils down to a duplicate of issue 46681: in Excel, the one-dimensional result vector of $E$8:$E$217=Z$9 is repeated as many times as it is needed to multiply it with the two-dimensional result array of $A$8:$W$217=$Y15. In Calc, the vector is not repeated, therefore the remaining columns are all 0 and the result of the multiplication is a vector of 0s too. To achieve identical results in Excel and Calc, the formula could be rewritten as =SUMPRODUCT(($F$8:$F$217=$Y14)*($E$8:$E$217=Z$9)) note the now one-dimensional array $F$8:$F$217 of the column that is of interest here. Doing so would also increase speed of calculation since only the relevant column would have to be evaluated instead of 23 columns of which 22 are not needed for the result. Eike *** This issue has been marked as a duplicate of 46681 *** --------------------------------------------------------------------- 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]