Perhaps

=SUMPRODUCT(--(Analyses!$A$1:$A$10000=B8),--(Analyses!$DX$1:$DX$10000>0))