Averaging time over multiple cells and YTD

[jaybird2569]

I have a spreadsheet to track employee efficiency over 16 different tasks. I am currently using formulas to determine their overall efficiency for the month by multiplying their time spent on each task (variable) by the amount of time it takes to do each task (constant). One of the issues is I can't add straight across the column because I have the number of tasks, constant and actual time. I then add all of the actual times across the column and divide by the number of hours worked for that month.
The formulas are ridiculous and get even more complicated as the months go on because I'm also trying to keep YTD totals but I can't just average all of the averages. I'm looking for an easier way to calculate this either VBA to run through the sheet and adding the columns for each person or keep using formulas that I have to create every month that's starting to take several hours to write. I currently have a formula that is adding 16 "totals" for each month divided by the total hours worked to get the YTD efficiency. For November that will be 176 totals (16x11) divided by 11 total hour cells. There has to be a better way. Maybe I need to set up the spreadsheet differently. Oh, by the way, I am a noob. I will post a screenshot later today.
Thank you in advance.