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