Sum Product

 =SUMPRODUCT($B$2:$B$9999=$B2)

Comments