Excel

S

Sherri

Where ever the word "Hanks" is found Count Count the non-blanks cells in
column D
 
P

pinmaster

Maybe something like this:

=SUMPRODUCT((A1:A100="frank")*(D1:D100<>""))

HTH

Jean-Guy
 
Top