What Formula Can Avg.

[rockyw]

I have a spreadsheet I track percents, 92, 89. ect for each day. I track this by the week, on Monday I erase the old week and put in new data for the new week. I want to keep a running avg. of these by week, month and by year. I can keep a running Avg for the week with =AVERAGE (ect), is there a way I can keep an avg. of the Month, and Year? The data would have to stay in the formule and keep updating with the new numbers. is this possible? Or do I need to keep a total some place that tracks each weeks data for a month and year Avg. Thanks

 

[bensonsearch]

I have a spreadsheet I track percents, 92, 89. ect for each day. I track this by the week, on Monday I erase the old week and put in new data for the new week. I want to keep a running avg. of these by week, month and by year. I can keep a running Avg for the week with =AVERAGE (ect), is there a way I can keep an avg. of the Month, and Year? The data would have to stay in the formule and keep updating with the new numbers. is this possible? Or do I need to keep a total some place that tracks each weeks data for a month and year Avg. Thanks

would have to store the total somewhere.eg: in a cell far far away