answersLogoWhite

0

Yes, it can be done. The trick is to use absolute reference in your average formula. Say you have your figures in column A, with the first in A2, assuming you have a heading in A1. Then in B2 put the following formula:

=Average(A$2:A2)

That will give the Average of the first cell, which will of course be the value in A2. But as you copy the formula down column B, you will find it keeps averaging from A2 down to the current value beside the formula. So as the formula copies down, you get a running average. Using Sum, you can do the same thing to get a running total.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is Excel and Entourage?

Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.


On Microsoft Excel what do you need to write to calculate things?

Formulas.


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


Can Microsoft Excel find moving average?

Yes it can. Say you have you values listed from cell A2 to A20, then in B2 you could enter the following formula and copy it down and it would get your moving average: =AVERAGE(A2:A$2)


How do you calculate a discount in Microsoft Excel?

See the explanation in the related link.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


How does Microsoft Excel helps in accounting?

It can calculate numbers and set out tables and graphs


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Who created Microsoft Excel?

Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.


Is there any hidden game in Excel 2003?

There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.