Hopefully it may work too...

=SUM(IF(FREQUENCY(IF(B2:B25=E2,IF(A2:A25<>"",MATCH(A2:A25,A2:A25,0))),ROW(A2:A25)),1))

(confirmed with CTRL+SHIFT+ENTER)