Replace words by numbers and calculate mean II

Hello,

in this post
https://www.excelforum.com/excel-for...ml#post5057419

I thought that the problem was solved, but now I'm trying the formula with more data and it is not working fine.
Here I attach the old excel file (points.xls) and the new one (points3.xls)
In points3.xls I tested the words in A2: "Getting ready for lights out" and the result for this should be 5,684 as shown in K7, but the formula calculates 5,13 as shown in G2.
I attach both files.. I think that the problem is that now in points3.xls it finds more words in D column that match those in A2 for example it finds "ready" but it also finds "already" and uses both of them to calculate the average.. but I can't find out how to solve that

As this is a continuation of your original question, please continue in that thread.

As this is a duplicate, I will submit a request for it to be locked.