Sumifs alternative

English
, ,
#1

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?

Sumif two criteria in different row/column
#2

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

#3

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.

#4

Try this:

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

AVERAGEIFS: =SUMIFS/COUNTIFS
#5

Hi Paijo,

this functions are supported from 4.x versions.

http://www.libreoffice.org/download
http://downloadarchive.documentfoundation.org/libreoffice/old/

#6

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.