https://bugs.documentfoundation.org/show_bug.cgi?id=98873
JoNi <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from JoNi <[email protected]> --- you can't have an 'array' for the range where the criteria is applied and a 'matrix' for the range with the sum values. Both ranges must have the same dimensions! For your purpose you need a matrix function (ctrl+shift+enter) =SUM(IF(RowNbr=R4; Racks) ) or =SUM(IF($C$4:$C$145=R4;$D$4:$P$145)) apply with ctrl+shift+enter -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
