average positive numbers

[Guest]

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

 

[JE McGimpsey]

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

=AVERAGE(IF(A1:A100>0,A1:A100))

 

[Don Guillett]

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

=AVERAGE(IF(H2:H10>10,H2:H10))

 

[Ron Rosenfeld]

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

=SUMIF(rng,">0")/COUNTIF(rng,">0")

The above does not include "0" values.


--ron