[Libreoffice-bugs] [Bug 137763] Aggregate(1; 6; ..) (Avg): different conditions => same value or single values and not the average

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137763

--- Comment #10 from Mike Kaganski <mikekaganski at hotmail.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201027/758a1b38/attachment.htm>