Thread: skip 0 average
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default skip 0 average
Non array formula

=SUM(A1:A6)/COUNTIF(A1:A6,"<0")

Just press enter



"Ken" wrote:

How do average a colum of numbers? I will ignore the $0 number.

Thank you very much!
Reply With QuoteReply With Quote