"sumif" and part of a word problem

[Gordon Blackstone]

Hello from the sunny Switzerland!

Here is my problem:

column b: different words
column e: numbers

i want to sum all the number in column e if the have the same word in column b

For a unique value (a word)
=SUMIF(B2:B62,"apple",E2:E62)

But how to do the same with a part of a word or sentence in the cell?:
cell value: "have a nice day" and i want to check the value "nice" or
"ice" of the sentence

Use of wild cards? how?

Merci!

 

[JE McGimpsey]

Hello from the sunny Switzerland!

Here is my problem:

column b: different words
column e: numbers

i want to sum all the number in column e if the have the same word in column b

For a unique value (a word)
=SUMIF(B2:B62,"apple",E2:E62)

But how to do the same with a part of a word or sentence in the cell?:
cell value: "have a nice day" and i want to check the value "nice" or
"ice" of the sentence

Use of wild cards? how?

One way:

=SUMIF((B2:B62,"*ice*",E2:E62)

 

[Gordon Blackstone]

One way:

=SUMIF((B2:B62,"*ice*",E2:E62)

Great perfect! Thank you JE McGimpsey!

And what about if you want to have the value "*ice*" in cell (not in
the formula)?

exple: =SUMIF((B2:B62,"*G2*",E2:E62)
and G2 contains ice??

 

[JE McGimpsey]

And what about if you want to have the value "*ice*" in cell (not in
the formula)?

exple: =SUMIF((B2:B62,"*G2*",E2:E62)
and G2 contains ice??

One way:

=SUMIF(B2:B62,"*"&G2&"*",E2:E62)

 

[Gordon Blackstone]

One way:

=SUMIF(B2:B62,"*"&G2&"*",E2:E62)

logical!

MERCI!