Average Formula

[ceblaser]

I need help creating an average formula that will only average those
numbers that are greater then 0. For example if I have 3,0,3,3,6,5
I need a formula that will average only 3,3,3,6,5.

Any help would be appreciated.

Thanks

 

[Jason Morin]

One way:

=SUMIF(A1:A10,">0")/COUNTIF(A1:A10,">0")

HTH
Jason
Atlanta, GA