Thread: How do I average a column without including zeros
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default
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.

Reply With QuoteReply With Quote