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

Shackra
11 ● 1

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

5693 ● 3 ● 48 ● 41

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)

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted

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

jofilho

503 ● 2 ● 10

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

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

link delete flag offensive edit

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

Kotian
1 ● 1 ● 1

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

link delete flag offensive edit

Comments

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

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

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

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

Seen: 133 times

Last updated: Jun 03 '12

AVARAGE.IF with Excel compatibility?