Sumifs alternative

I knew that LibreOffice not yet support the Excel ‘*IFS’ (sumifs, averageifs, countifs, etc) functions.

Is there any alternative formula for conditional sum with more than one criteria?

Your information is out of date: Calc supports these functions beginning from the version 4.0

Thank you for the information. I just opened the old xlsx file few days ago, and value in the cell showing error. But when I open the same file today, it suddenly working. I don’t know why.

Try this:

COUNTIFS: =SUMPRODUCT(criterion1;criterion2;...;criterionx)
SUMIFS: =SUMPRODUCT(criterion1;criterion2;...;criterionx; sum_values)


Hi Paijo,

this functions are supported from 4.x versions.