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

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

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

On 12 Jun, 21:41, deana wrote:
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