Formulas: Averages
 

I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent function
for average is =Average().

I just need a formula that recognizes the current number and the ones before
it.

Formulas: Averages
 

KeithD wrote:
I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent function
for average is =Average().

I just need a formula that recognizes the current number and the ones before
it.

This is basically about

http://www.cpearson.com/excel/relative.aspx

Write back if you are still confused.

Formulas: Averages
 

hi
assuming that your dates are in column A and start at A2 and your numbers
are in column B, starting at B2 then this formula might do it for you.

=SUM($B$2:$B2)/(ROW()-1)

copy down as far as you need.

regards
FSt1

"KeithD" wrote:

I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent function
for average is =Average().

I just need a formula that recognizes the current number and the ones before
it.

Formulas: Averages
 

hi
do a search on your log in name. you'll find them.

Regards
FSt1


"KeithD" wrote:

I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent function
for average is =Average().

I just need a formula that recognizes the current number and the ones before
it.

Formulas: Averages
 

Try this...

=AVERAGE(B$1:B1)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"KeithD" wrote in message
...
I would like to know how to create a "To-Date" average. For example, lets
say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent
function
for average is =Average().

I just need a formula that recognizes the current number and the ones
before
it.

Formulas: Averages
 

disregard this reply. post in the wrong place.
oops.

FSt1

"FSt1" wrote:

hi
do a search on your log in name. you'll find them.

Regards
FSt1


"KeithD" wrote:

I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:

Nov 1
Nov 2
Nov 3

and I have numerical values for each date:

Nov 1 | 100
Nov 2 | 106
Nov 3 | 88

How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to the right of Nov 2 is 103 [(100+106)/2],
and to the right of Nov 3 is 98 [(100+106+88)/3]. I know the parent function
for average is =Average().

I just need a formula that recognizes the current number and the ones before
it.