View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default searching and summing using string within cell

Hello,

What about:

=SUMIF(D1:D10,"*Junior*",K1:K10)

Regards,
Bondi