Ask Your Question
0

Sumifs alternative [closed]

asked 2013-05-20 10:26:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-01 14:12:51.416830

Comments

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

JohnSUN gravatar imageJohnSUN ( 2013-05-20 14:52:44 +0200 )edit

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.

Paijo gravatar imagePaijo ( 2013-05-21 07:34:21 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-05-20 23:47:49 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

edit flag offensive delete link more
0

answered 2013-05-20 14:56:23 +0200

JohnSUN gravatar image

Try this:

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

AVERAGEIFS: =SUMIFS/COUNTIFS
edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-05-20 10:26:28 +0200

Seen: 6,244 times

Last updated: May 20 '13