https://bugs.freedesktop.org/show_bug.cgi?id=74479
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #4 from mariosv <[email protected]> --- Hi fwiubqpbvuebeqpnEX32nfi3vinkqjfG, in this thread I have found a similar ussue: http://en.libreofficeforum.org/node/7523#comment-30361 Seems that when there is function in the last parameter of SUMPRODUCT(), empty cells in one of the ranges are taken as 1. In your sample file: B21: =SUMA.PRODUCTO((DÍASEM($A$20:$A$22;2)=6)*1;A20:A22) => 0 B21: =SUMA.PRODUCTO(A20:A22;(DÍASEM($A$20:$A$22;2)=6)*1) => 3 So sorry you are in reason a bug is there. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
