View Single Post
  #1   Report Post  
JT
 
Posts: n/a
Default Find AVG/MIN of a Column, excluding 0's and NULL's?

Hello,
How do I average a column of numbers, but exclude cells that contain 0's or
Null's? I don't want 0 figured into the average value.
Secondly how do I find the MIN, but exclude 0's in the calculation?
Thanks in advance.
JT