RE: Average MTD percentage

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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%
>
>
.

Relevant Pages

  • Re: Sum challenge
    ... Christopher Weaver wrote... ... >I would like to create a formula in column A that sums the values in ... the first row in column B that is not blank. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Tennis Magazine: Sampras Best Ever, Navratilova 2nd, Graf 3rd, Evert-Lloyd 4th
    ... that about sums it up, though i'd say he introduced the robotic, ... mechanistic eastern-bloc athletic approach to tennis. ... one else followed suit ... ... Prev by Date: ...
    (rec.sport.tennis)
  • Re: Yokos betrayal of John
    ... What does fattush do to deserve to getting flamed by ... Francie?" ... That sums it up. ... Prev by Date: ...
    (rec.music.beatles)
  • Sum challenge
    ... I would like to create a formula in column A that sums the values in column ... E starting with the row in which the formula resides and moving upward to, ... A static range ... Prev by Date: ...
    (microsoft.public.excel)
  • RE: "Greater than" and "lower than"
    ... This sums all values that are numbers, then divides by the count of all ... I work at a lab, and when we get results that our equipment can not measure ...
    (microsoft.public.excel.misc)