The problem:

The cell in column M and N would need to lookup the name found in the A column and then find wherever they are used in sheet4 (which I mentioned
acted as the array), then to the right of the cell where the name is found in sheet4, the score will be present. For some members, they
have multiple scores (meaning they have been entered numerous times on the sheet. This is intended). I would need for all the scores for the specific member to be added up and added under the "Total Score"(N) column in their
respective cell on the "testdb" sheet. As for the average score (M) column, I would like for their averages to be entered there.

I have tried so much but this seems beyond me.
Thank you for any assistance.

I have attached a file called EFFile

(ExcelForums EFFile.xlsm).