View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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