Ask Your Question
0

Calc: Averageif [closed]

asked 2012-06-03 13:22:39 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How do I translate this Excel =averageif(C6:C19;">0") into calc?

I just want the average, but without dividing with the numbers of cells with a 0 eg I have 12 cells, 4 with numbers and the rest with 0 so far - want to get the return avagere sum/4 and not sum/12 - next month It will be sum/5 ...

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:30.299613

1 Answer

Sort by » oldest newest most voted
0

answered 2012-06-03 14:19:56 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

=sumif(C6:C19;">0")/countif(C6:C19;">0")

edit flag offensive delete link more

Comments

=sumif(C6:C19)/countif(C6:C19;">0") works with less effort and in LibreOffice 5.1 =AVERAGEIF(C6:C19,">0") would now work.

Rolf23 gravatar imageRolf23 ( 2017-06-19 08:21:21 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2012-06-03 13:22:39 +0200

Seen: 5,779 times

Last updated: Jun 03 '12