AVERAGE.IF with Excel compatibility?


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)

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

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

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