Thread: How to average a column, but exclude zero AND negative values?
View Single Post
  #1   Report Post  
KMHarpe
 
Posts: n/a
Default How to average a column, but exclude zero AND negative values?
I used the formula of =AVG(IF(A1:A10)<0,A1:A10)) to exclude just the zero
values, but what about zero AND Negative?

Thanks!!
Reply With QuoteReply With Quote