Average/Min column of numbers, but skip 0's and Null's in the form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sorry for the triple post. I keep getting an error message after posting to
try again later.
JT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find AVG/MIN of a Column, excluding 0's and NULL's? 3
Average Column, but Skip Null and 0? 1
Averaging two ranges on the same column (excluding zeros) 2
AVERAGE 7
average without min qty 1
Trying to find additional ranges outside of min, max, and average 2
How do I exclude the HIGH and LOW values in the =AVERAGE function 2
Excel Average dates help 0

Back
Top