Average non zero values
I recall reading this and now cant find it.
A column of data with numerical values, some empty cells and some with zero's.
I need to calculate the average, but supress cells with zeros from the
calculation.
I tried =IF((A1:A44)<0,AVERAGE(A1:A44)) arrayed entered, but no go.
Suggestions welcomed, and my thanks.
Paul
|