search

[oleg_v]

Hello,i have a file attached with the list.the list is the problems with the product.I would like to get some help to summarise the rows.for example: if there are i few row that contains the word "leakage".
thank you

[nilem]

maybe
=SUMIF(D7:D196,"*leakage*",E7:E196)
or
=SUMIF(D7:D196,"*"&H4&"*",E7:E196)
the value in cell H4 - leakage

[oleg_v]

hi thanks for the replay.
the most important thing for me is to find a similar words.