View Single Post
  #3   Report Post  
Susannah
 
Posts: n/a
Default

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?