asked 2012-06-03 13:22:39 +0200
This post is a wiki. Anyone with karma >750 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 ...
answered 2012-06-03 14:19:56 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
=sumif(C6:C19;">0")/countif(C6:C19;">0")
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!
Asked: 2012-06-03 13:22:39 +0200
Seen: 532 times
Last updated: Jun 03 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
