https://bugs.documentfoundation.org/show_bug.cgi?id=158789
--- Comment #1 from ady <adylo811...@gmail.com> --- Several points. In addition to this tdf#158789, you also filed tdf#158788, apparently trying to solve some issue with how to arrive to some result. Please understand that most of us are volunteers here. This site is for reporting bugs and enhancement requests, not a support forum. You could go to <https://ask.libreoffice.org> for that, for instance. Now, as for the result you seem to be trying to obtain, I am about to post one possible alternative. This is not a complete solution, and most probably not even an efficient formula; it is just a way to show you that instead of asking for changing a function here you could just go to some forum and ask for help in finding the result you want. So, here is one way (of several) to obtain an array formula with what you need (as far as you presented it in comment 0): =SUM({-10;10;20;30}*({-10;10;20;30}>0)) to be introduced not with [Enter] but with [Ctrl]+[Shift]+[Enter] (CSE). For further help with your formula, or better alternatives (they surely are available out there), I'm going to respectfully and politely ask you to please use a more adequate site, leaving this for actual bug reports and enhancements requests. IMO, this is neither. Others might not agree. -- You are receiving this mail because: You are the assignee for the bug.