This is a long one... Assume your dates are in the range A1:A10 and your
Recovery is in B1:B10:

=SUMPRODUCT(--(MONTH(A1:A10)=MONTH(TODAY())),--(B1:B10<0),--(B1:B10))/SUMPRODUCT(--(MONTH(A1:A10)=MONTH(TODAY())),--(B1:B10<0))

Basically this sums all values in column B that fall within the current
month, and divides by the number of values that fall within the current month
and are not 0.

Hope that helps,

--
David Billigmeier


"Mike Punko" wrote:

Trying to setup a column to show the Month to Date average. My data sheet
looks like this. I also need this not to average 0.0% values

DATE RECOVERY MTD
1/1/05 95.4%
1/2/05 95.2%
1/3/05 92.3%
1/4/05 0.0%
1/5/05 91.2%