how do you use microsoft excel to calculate year to date average

[deana]

i am setting up a spreadsheet for work and want to be able to enter monthly
statistics and have a year to date percentage calculation. i want to be able
to sit with employees each month a say this is your sales figures for Jan,
Feb ... and so far this is your year to date sales average. Each time I get
new monthly statistics and enter into the spreadsheet I want the year to date
average to change.
Hope this is clear enough to understand what my objective is

thanks

 

[Peter]

i am setting up a spreadsheet for work and want to be able to enter monthly
statistics and have a year to date percentage calculation. i want to be able
to sit with employees each month a say this is your sales figures for Jan,
Feb ... and so far this is your year to date sales average. Each time I get
new monthly statistics and enter into the spreadsheet I want the year to date
average to change.
Hope this is clear enough to understand what my objective is

thanks

Sub haydn()
icolumn = 1
irow = ActiveSheet.UsedRange.Rows.Count
Cells(irow + 1, icolumn).Formula = "=Average(" & ((Chr(icolumn + 64))
& "1:" & (Chr(icolumn + 64)) & irow & ")")
End Sub

Peter