I hope you don`t fell offended, I tried both suggested formulas.
Nobody is offended.

You haven't updated the ranges to match the real data - of course it won't work!

Provide a more realistic workbook (desensitised).