Average the POSITIVE values only
for example:
=AVERAGE(IF(A1:A60,A1:A6))
array entered with Cntrl+Shift+Enter
or try:
=AVERAGE(IF((A1:A6=0)*(LEN(A1:A6)),A1:A6))
to include zero values (and exclude empty cells that would be treated as
zero values)
"John" wrote:
How do I average all the numbers in a column but only the positive numbers in
that column?
|