Average of a row of numbers not counting 0's

[BobS9895]

I have a range of numbers, A10:L10, which represents headcounts during
the month. These numbers are a formula, not a manual input. If the
month has not occurred yet, the number equals 0. I want to add a
formula telling me my average headcount per month. However, because
the 0's are included, my average is always understated. Is there a way
to calculate the average while ignoring the 0's? I know I can do it by
deleting the 0's, but since it is a formula, I prefer not doing that.

 

[Guest]

=IF(SUM(A10:L10)>0,SUMIF(A10:L10,">0")/COUNTIF(A10:L10,">0"),"")

Vaya con Dios,
Chuck, CABGx3

 

[Dave]

BobS9895

Try this

=(SUM(A10:L10)/COUNTIF(A10:L10,"<>0"))

Dave

 

[BobS9895]

Thanks to both of you!

BobS9895

Try this

=(SUM(A10:L10)/COUNTIF(A10:L10,"<>0"))

Dave