Thank you guys so much. So this is where I'm at now... and I'm feeling a little dumb lol


I plugged in this formula:
=IFERROR(AVERAGEIFS($E$3:$E$15,$F$3:$F$15,"*AVE",$ E$3:$E$15,"<>"),"")

and got the correct average for the clients on one week. The issue I'm facing now is how get the average for multiple weeks so that I can get an average per client for the entire month.

Any help is appreciated!!

Thanks!