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