I mocked up your data as you provided it, with names in A1:A6 etc. I
entered "David" in A8 and this formula in B8:
=SUMPRODUCT(--($A$1:$A$6=A8),--($B$1:$B$6<""))