I would like to average an array of cells, but only include those cells whose
cell value is greater than zero.
I have an array like (D3;G3;J3), and want to include only those
AVERAGE(D3;G3;J3). I have tried to use
SUM(D3;G3;J3)/COUNTIF((D3;G3;J3);"0" )
but the COUNTIF doesn't allow that arrayform (D3;G3;J3). If I for example
put COUNTIF((D3:D7);"0") , that works - but that's not the cells where my
data is!
How should I write the array so that it works?
Yours
Karin