How about =sum($A:$A)/(countif($A:$A,"0"))

"latripl" wrote:

I am trying to do a formula for averaging a series of numbers (which I can
do) exept if there is zero in the series I want to ignore it in the avg. How
do I write an IF statement for this?