Ask Your Question

AVARAGE.IF with Excel compatibility? [closed]

asked 2012-05-09 00:44:11 +0200

Shackra gravatar image

updated 2013-02-01 09:32:48 +0200

qubit gravatar image


Calc have COUNT.IF and SUM.IF (or CONTAR.SI and SUMAR.IF in spanish version of Calc) but not AVARAGE.IF! so, What solution could I use to solve this? (hopefully, with compatibility with Excel)

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-10-16 04:36:59.708170

2 Answers

Sort by » oldest newest most voted

answered 2012-05-09 01:45:52 +0200

jofilho gravatar image

updated 2012-05-09 01:46:05 +0200

use together:, COUNT.IF()/SUM.IF(). It's compatible and works great.

edit flag offensive delete link more

answered 2012-06-03 13:41:04 +0200

Kotian gravatar image

works - though not SumIF but just Sum - AND Sum()/Count.IF() to get AvarageIF

edit flag offensive delete link more


Nope! If you want to have something like "AVERANGEIF()" you have to use SUMIF()/COUNTIF(). Other ways will return wrong values.

jofilho gravatar imagejofilho ( 2012-06-04 04:52:45 +0200 )edit

Question Tools


Asked: 2012-05-09 00:44:11 +0200

Seen: 327 times

Last updated: Jun 03 '12