IF function for Averages

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of months that have been worked.

Example:  Employee ONE works 12 hours in January.  The sheet would show 12 hrs for Jan. with a yearly total of 12 and a monthly average of 12.  When the employee works Fed and reports 16 hours the sheet would show his 12 hrs for Jan and now 16 hrs for Feb.  The yearly total would be 28 hrs. and the monthly average would be 14.  The fomula that I need is in calculating the monthly average as the number of months increase.

I am using Excel 2007 on a system with Windows 10 Home.

By: Larry Sapp

Leave a Reply

Your email address will not be published. Required fields are marked *