| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continuous Averages Formula
You know how you can set an entire column with the same formula by dragging at the bottom right hand corner of a formulized block... well I need help with a formula. Its a bit complicated to explain, but I'll try my best. I want a formula that will keep the running averages. 100 ave: 100.0 105 ave: 102.5 180 ave: 128.3 100 ave: 121.3 When I type in =AVERAGE(A1:A2) then I drag down the formula to affect the other lines... I want them to show =AVERAGE(A1:A3) =AVERAGE(A1:A4), etc... but it ends up showing =AVERAGE(A2:A3) =AVERAGE(A3:A4) Please help. -- Mof ------------------------------------------------------------------------ Mof's Profile: http://www.excelforum.com/member.php...o&userid=30892 View this thread: http://www.excelforum.com/showthread...hreadid=505660 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
