average positive numbers

S

Susannah

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

JE McGimpsey

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

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

Don Guillett

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

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

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?
Click to expand...


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

The above does not include "0" values.


--ron
 
Top