[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
bugzilla-daemon at bugs.documentfoundation.org
Tue Oct 27 10:04:44 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=137763
--- Comment #12 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to gooly from comment #11)
> This =AVERAGEIF(G11:G84;"Bu|Se";T11:T84)
> (in German: =MITTELWERTWENN(G11:G84;"Bu|Se";T11:T84) )
> causes "#DIV/0!"
> LO 7.0.3.1 (64)
... which means that you didn't allow regular expressions, as I mentioned in
comment 10.
--
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/1ed04d15/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list