average positive numbers
 

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

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?

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?

On Thu, 10 Feb 2005 17:05:01 -0800, "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?


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

The above does not include "0" values.


--ron