LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with monthly averages, and copying formulas SusanU Excel Worksheet Functions 3 September 24th 08 10:37 PM
first ten and last ten averages aazharr Excel Worksheet Functions 2 February 28th 08 03:28 PM
Averages Zygy New Users to Excel 16 June 19th 06 10:01 PM
Averages Beth Excel Worksheet Functions 4 March 9th 06 08:19 PM
Averages Karen Excel Worksheet Functions 3 January 5th 05 10:02 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"