using left function in sumproduct

Earlier I posted an issue where I needed to establish an*average % across*multiple columns where multiple criteria was met and BSB kindly solved this for me. I stupidly forgot to mention that on the attached,*I will also need to establish an average for the whole of Lay team. I'm trying to achieve this using left in my formula but it's just not working.

*

Can anyone help by amending the working individual lay team averages to provide a solution in cell m14 for me.

Sorry attachment not uploaded, I'll try again

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.