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 …