Re: Running Average
- From: Domenic <domenic22@xxxxxxxxxxxx>
- Date: Wed, 01 Jun 2005 15:58:04 -0400
If Column A contains true date values...
=AVERAGE(E1:INDEX(E1:E31,MATCH(TODAY(),A1:A31,0)))
If Column A contains dates as text values, in the format June 1 05...
=AVERAGE(E1:INDEX(E1:E31,MATCH(TEXT(TODAY(),"mmmm d yy"),A1:A31,0)))
If the dates are text values and are abbreviated to three letters, such
as Jun 1 05, change 'mmmm d yy" to "mmm d yy".
Hope this helps!
In article <iBnne.6197$Hj.1638@lakeread02>, "Mike" <windme@xxxxxxx>
wrote:
> thanks guys for your quick response, but I'm still having a problem.
> in Bob's formula it says that the formula contains an error and the curser
> going in between the () of the date. When I enter just the
> =average(indirect("E1:E25)) it works so the problem lies in the original
> formula =average(indirect("E:E"&day(date())). Wouldn't i have to tell it
> where to find the date (in column A?).
>
> In Domenic's after enterting the formula it gives me the total average for
> all the days listed.
> thanks in advance,
> Mike
.
- Follow-Ups:
- Re: Running Average
- From: Mike
- Re: Running Average
- References:
- Running Average
- From: Mike
- Re: Running Average
- From: Bob Umlas
- Re: Running Average
- From: Mike
- Running Average
- Prev by Date: Re: Excel to Access
- Next by Date: Re: Import large text file
- Previous by thread: Re: Running Average
- Next by thread: Re: Running Average
- Index(es):
Relevant Pages
|
