Calc: Averageif

[Kotian]

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 …

[mariosv]

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

[Rolf23]

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