A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formulas: Averages



 
 
Thread Tools Display Modes
  #1  
Old November 14th, 2009, 04:41 AM posted to microsoft.public.excel.misc
KeithD
external usenet poster
 
Posts: 5
Default 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.
Ads
  #2  
Old November 14th, 2009, 05:17 AM posted to microsoft.public.excel.misc
smartin
external usenet poster
 
Posts: 780
Default 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.
  #3  
Old November 14th, 2009, 05:46 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default 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.

  #4  
Old November 14th, 2009, 05:47 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default 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.

  #5  
Old November 14th, 2009, 05:53 AM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default 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.



  #6  
Old November 14th, 2009, 06:13 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default 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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.