this is an ARRAY formula so must be entered/edited with ctrl+shift+enter

=AVERAGE(IF(H2:H1010,H2:H10))

--
Don Guillett
SalesAid Software

"Susannah" wrote in message
...
Simple question...I'm trying to obtain an average but only want to include
those cells with positive numbers in the average. Any ideas?