Another way:
=SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail sheet'!$B$1:$B$10<>""))
HTH
Jean-Guy
Another way:
=SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail sheet'!$B$1:$B$10<>""))
HTH
Jean-Guy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks