https://bugs.documentfoundation.org/show_bug.cgi?id=137763
--- Comment #10 from Mike Kaganski <[email protected]> ---
(In reply to gooly from comment #9)
Nice!
Now, after the bug had been resolved, here is my advise for your original task:
if you need to get average for some values, you may use this in T12:
=AVERAGEIF(G11:G84;"Bu|Se";T11:T84)
... if you use regular expressions in your spreadsheet (see
Options->Calc->Calculate). This is much simpler (and more manageable) than
=AGGREGATE(1;6;T11:T84/((E11:E84="Se")*(F11:F84="Se")+(E11:E84="Bu")*(F11:F84="Bu")))
--
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
