Thread: skip 0 average
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default skip 0 average
=AVERAGE(IF(A1:A6<0,A1:A6))

ctrl+shift+enter, not just 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