How to average a column, but exclude zero AND negative values?

I used the formula of =AVG(IF(A1:A10)<>0,A1:A10)) to exclude just the zero
values, but what about zero AND Negative?

Thanks!!

=AVerage(IF(A1:A10)>0,A1:A10))

Still array entered.


KMHarpe wrote:
>
> I used the formula of =AVG(IF(A1:A10)<>0,A1:A10)) to exclude just the zero
> values, but what about zero AND Negative?
>
> Thanks!!

--

Dave Peterson