How do I average positive numbers only
 

How do I average positive numbers only while ingnoring any zero or negative
values?

=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?

Thank you! One further question...I see how this works with sequential cells;
but if I want to average positive valued data from E7,E12,E22,E27 I can't
seem to get it to work.

Thank you in advance Peo!

"Peo Sjoblom" wrote:

=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?