https://bugs.freedesktop.org/show_bug.cgi?id=58874
--- Comment #4 from GerardF <[email protected]> --- A workaround for your sample : Add a column with the formula =SUBTOTAL(3;A9) in H9 and drag down (with filter to "All") Then =SUMPRODUCT($H$9:$H$260; --($G$9:$G$260=H4)) will gives you the result with a simpliest and shorter formula. You need 3.6.7/4.0.4/4.1.0 minimum, see https://bugs.freedesktop.org/show_bug.cgi?id=64384 -- 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
