Daily Average

[Manish Jain]

Hi Friends,

Please check the attached file and summary at the bottom. I want the average of previous month to be updated as soon as I enter data in current date. For eg if data entered is till 20th September 2014 then average of data of Day 1 to Day 20 updates automatically. When i enter data on 21st September, the average of 1-21 days of previous months updates automatically. Please help. Thanks a lot

 

[echo99]

@Manish Jain please see the attch may be this can help.

 

[Manish Jain]

@Manish Jain please see the attch may be this can help.

Thank you for your effort, but its not serving the purpose as average of Months April-August not updated

 

[echo99]

you must copy formula to April-August ect.

Regards,
echo99

 

[Manish Jain]

Its not working