The formula is

=SUMIF(A:A,"*bc*",B:B)

Where column A contains the text amd column B contains the cells you wish to
sum.

Note if you prefer you can enter ranges instead of columns.



"Michal" wrote:

How to sum cells which contains the same sequence of letters? i mean I have a
column with following texts: abcd, bcde, cdef. How to sum cells which contain
"bc" sequence?