Average the POSITIVE values only
Thanks! By the way, how do you enter an arrayed function...or what does that
mean exactly? Is it just a formula that, after you enter into the Fx bar,
you hit ctrl+shft+enter instead of just enter?
"joeu2004" wrote:
On Nov 7, 7:09 pm, John wrote:
How do I average all the numbers in a column but only the
positive numbers in that column?
Two methods come to mind.
1. =average(if(A1:A200,A1:A20))
That is an array formula; commit with ctrl-shift-Enter.
2. =sumif(A1:A20,"=0") / countif(A1:A20,"=0")
That is not an array formula; commit with Enter, as usual
|