How do I average a column without including zeros

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

[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.

[Dave Peterson]

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

[pgriff]

Probably not a good idea to average %s anyway. Get your average from the data.