For example I need an combined average for all percentages to the left of all clients listed as AVE and OAVE: C5,C6,C8,C11,C13,E5,E6,E8,E11,G6,G8,G9,G11,G13 ect...



I am aware of how to get this manually each month. I'm just trying to get help with a formula that will calculate an average percent based on the percentages to the left of each client name.

I hope that makes since... Please let me know if you need more clarification, sorry.
Again thank you for helping.