Amazing stuff. Perfect. Thank you my friend.
--
KDDXB


"Dave O" wrote:

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<""))