Ask Your Question
1

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

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)

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
1

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
0

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

Comments

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

Stats

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

Seen: 318 times

Last updated: Jun 03 '12