How do I average a column without including zeros

K

KMHarpe

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!!!
 
D

Dave Peterson

Maybe..

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


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!!!
Click to expand...
 
D

Dave O

There may be a snappy built-in function in Excel to do this, but until
someone responds with it, this formula will work:
=SUM(D1:D5)/COUNTIF(D1:D5,"<>0")

.... where D1:D5 is the range containing your percentages.
 
Top