How to average a column, but exclude zero AND negative values?

G

Guest

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!!
 

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

MAX() of a range of negative values? 7
How do I average time (hh:mm:ss) excluding zeros? 2
Need help (Average excluding zero values) 2
formula for countIf with two conditions 2
Help understanding CSE results 5
getting the min and max of a list of numbers 9
ignore MAX and MIN values in a set to calculate average 5
replace a negative result with a zero? 2

Top