Another way:

=SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail sheet'!$B$1:$B$10<>""))



HTH

Jean-Guy