=SUMPRODUCT(--(MONTH(A1:A10)=MONTH(TODAY())),--(B1:B10<0),--(B1:B10))/SUMPRODUCT(--(MONTH(A1:A10)=MONTH(TODAY())),--(B1:B10<0))
Been trying to play with this code but to no resolve. I still get the
#DIV/0! error for the results. I tried setting the < to just or < since
the 95.4% is actually 0.954 turned into percentage. But still no go. I
played around with the date format, I even checked to see that the MONTH and
TODAY function part of the coding pulled teh right numbers and it did. Could
anyone else maybe see why this code isn't working for me?

"David Billigmeier" wrote:

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%