RE: excel moving average
- From: "edba" <edba@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Apr 2005 17:18:03 -0700
Works great! I really appreciate the help. I forgot the quotation marks
around the greater sign. I ended up replacing the now() functionin your
equation with a cell reference. That allows the user to change the function
"now()-180" without messing around with the criteria that I like to keep
hidden when possible.
"JBoulton" wrote:
> Use two criteria cells one is =">"&NOW()-180 and the other is "<"&NOW().
>
> This will give you the average of everything between now and six months ago.
> You can change 180 to whatever you want if that's not exact enough for your
> needs.
>
> "edba" wrote:
>
> > Need to calculate six month moving avaerage based on =now() and batabase
> > function daverage
.
- References:
- excel moving average
- From: edba
- RE: excel moving average
- From: JBoulton
- excel moving average
- Prev by Date: Re: how does one convert text to a formula "average(A:A)" to =average(
- Next by Date: Re: how does one convert text to a formula "average(A:A)" to =average(
- Previous by thread: RE: excel moving average
- Next by thread: How can I sort multiple months/years WITHOUT Alpha order taking o.
- Index(es):
Relevant Pages
|
Loading
