AVERAGE.IF with Excel compatibility?

[Shackra1]

hello!

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)

[jofilho]

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

[Kotian]

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

[jofilho]

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