How do I average a column without including zeros

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.