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

J

JT

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
 
J

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
Trying to find additional ranges outside of min, max, and average 2
Averaging two ranges on the same column (excluding zeros) 2
AVERAGE 7
Not having luck with any examples of averaging... 2
Average Column, but Skip Null and 0? 1
Changing the range for averages with out changing the formula. 0
Subtraction from the lowest number postion wise in Column 3

Top