https://bugs.documentfoundation.org/show_bug.cgi?id=92915
--- Comment #15 from Alexander Nolting <[email protected]> --- Hello Karl, I digged into your issue and found that LO doesn't support the {COUNT,SUM,AVERAGE}IFS starting from Excel 2007 onwards. Below you find an idea to substitute this by using SUMPRODUCT(). SUMIFS( range ; column1 ; ">1" ; column2 ; "<5" ) <==> SUMPRODUCT( range * column1>1 * column2<5 ) COUNTIFS( column1 ; ">1" ; column2 ; "<5" ) <==> SUMPRODUCT( column1>1 * column2<5 ) AVERAGEIFS <==> SUMIFS/COUNTIFS My last two comment are for Miguel. Best regards Alex -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
