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. 


Thread Tools  Display Modes 
#1




Formulas: Averages
I would like to know how to create a "ToDate" 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 "todate" 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




Formulas: Averages
KeithD wrote:
I would like to know how to create a "ToDate" 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 "todate" 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




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 "ToDate" 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 "todate" 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




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 "ToDate" 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 "todate" 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




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 "ToDate" 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 "todate" 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




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 "ToDate" 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 "todate" 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  

