How do I average a column without including zeros
 

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

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

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.

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


--
pgriff
------------------------------------------------------------------------
pgriff's Profile: http://www.excelforum.com/member.php...o&userid=26189
View this thread: http://www.excelforum.com/showthread...hreadid=394952