Thread
:
How do I average positive numbers only
View Single Post
#
2
Peo Sjoblom
Posts: n/a
=AVERAGE(IF(Range0,Range))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Susannah" wrote in message
...
How do I average positive numbers only while ingnoring any zero or
negative
values?
Reply With Quote