Vexing problem, can anyone help please?

Hello and thank you in advance,   The problem I'm having is that the formula is correct and works (thanks to click and drag), but not all rows return the answer even though there is data in the sou...