To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54885
------- Additional comments from [EMAIL PROTECTED] Wed Sep 21 04:22:13 -0700 2005 ------- Hi Rainer, > =SUMMENPRODUKT(($A$8:$W$217=$Y12)*($E$8:$E$217=Z$9)) > Someone with more knowledge shuld decide: That's a correct formula for EXCEL > _and_ OOo? Yes, it is. OOo1.x didn't support it in its plain form though, you had to enter it as a matrix/array formula. This changed with OOo1.9.x for Excel compatibility. > To me it seems to be funny, that that formula has the result '210', if I use > it > in an empty calc document in 'Z12'. May look weird at the first impression, but is perfectly logical ;-) Internally, ($A$8:$W$217=$Y12) and ($E$8:$E$217=Z$9) create two arrays where each element is TRUE, the result of the comparison of an empty cell with an empty cell. The arrays are multiplied element by element, resulting in an array where each element has the value 1, and the elements are summed up then. As for the issue described by the submitter: without knowing the original data there's nothing we could say. I guess the 0 is because the comparisons produce results of FALSE, maybe because numbers are compared with strings, but this is just a guess. Eike --------------------------------------------------------------------- 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]
