Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of a running mean
I use a spreadsheet to record test scores - 12 per year. I want to have a
cell where the mean test score is calculated on a running basis - so if there are 2 tests entered the mean of the two is displayed, 3 testst enetred the mean of the three is displayed, and so on. Yesterday I received the suggestion that I use =AVERAGE(Cell addresses), but when I try that it cannot cope with the empty cells which are for test scores that have yet to be inputted. Is there a way of doing this? I am using Excel 2003 and don't have access to the additional statistics package. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of a running mean
With the test scores in A1 - A12 try this:-
=SUM(A1:A12)/COUNTIF(A1:A12,"0") Mike "clatters69" wrote: I use a spreadsheet to record test scores - 12 per year. I want to have a cell where the mean test score is calculated on a running basis - so if there are 2 tests entered the mean of the two is displayed, 3 testst enetred the mean of the three is displayed, and so on. Yesterday I received the suggestion that I use =AVERAGE(Cell addresses), but when I try that it cannot cope with the empty cells which are for test scores that have yet to be inputted. Is there a way of doing this? I am using Excel 2003 and don't have access to the additional statistics package. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation of a running mean | Excel Discussion (Misc queries) | |||
Running Add-In from VBA | Excel Discussion (Misc queries) | |||
Pivot Table - Running Calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |