Maybe..

=SUM(A1:A10)/COUNTIF(A1:A10,"<"&0)



KMHarpe wrote:

I want to average a column that is all percentages, but I want to excluding
any cells with a 0%, what formula would I use? Thanks!!!

--

Dave Peterson