Thread: how do I get AVERAGE to ingore a zero value cell
View Single Post
  #2   Report Post  
Ola
 
Posts: n/a
Default
Try this:
=SUMIF(A1:A5,"<0")/COUNTIF(A1:A5,"<0")

Ola Sandstrom

Reply With QuoteReply With Quote