average formula

[ruthm8611]

I need a formula that will automatically average a ytd date total as each month of data is entered.

current formula is sum(a1..a3)/3 to get March total. When April data is entered, the formula is changed to /4. Can't this be automated so that the number of months does not have to be changed manually each month?

Thanks in advance for any assistance.

 

[VoG]

Try like this

=SUM(A1:A10)/COUNT(A1:A10)

 

[cjcobra]

=SUM(a1:a12)/counta(a1:a12)