Microsoft Office

Excel

The following gives the total of values in the E column where the text in the C column matches what's in I6

=SUMIF(C2:C98,"*"&I6&"*",E2:E98)