Excel formula

Hi Excel community. I am in need of some help. I have been working on this problem for a while and not able to work it out.   If you look at below image. I need help with Option B where I need prof...