Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ongoing Average Calculation
I have a spreadsheet created that receives data input throughout the month.
Once the whole month is filled in and the extra blank rows deleted there is a calcuation at the end that tells the average of row Q. It always shows #### until all the rows are either filled in or deleted. is there a way to have it calculate the average on an ongoing basis and when new data is input it will consider that in the calcualtion as well? Thanks, Tania |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average IF with calculation | Excel Worksheet Functions | |||
Calculation help from average total | Excel Worksheet Functions | |||
average calculation | Excel Discussion (Misc queries) | |||
Average Calculation | Excel Worksheet Functions | |||
Adding an ongoing value to an Average | Excel Worksheet Functions |