One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(A1:A1000,A1:A100))

In article ,
"Susannah" wrote:

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