https://bugs.documentfoundation.org/show_bug.cgi?id=170383
--- Comment #8 from nobu <[email protected]> --- When the result is a single cell and a numeric value, the SUMPRODUCT function can sometimes handle the array by avoiding array mode. This was a well-known method in Excel too. It might be useful if you need interoperability. SUMPRODUCT https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC#bm_id3163286 SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function. The SUMPRODUCT function won't work perfectly in every case, but the sample formula provided displays the correct value. =SUMPRODUCT(LET(chars,{"A","B"}, upper, FIND(chars, "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), COLUMNS(upper))) --> 2 -- You are receiving this mail because: You are the assignee for the bug.
