Formula: copy to clipboard
=SUMPRODUCT(($B$2:$B$11=D2)*($A$2:$A$11=""))


Alternative

Punnam