SumIf with cells that contain a certain word

[George Lob]

Is there a way to use the sumif statement with cells the contain a certain
word?
A B
1 John Doe 5
2 John Smith 5
3 Mary Jane 7

I want to add all the the value in column B if the value of column A
contains the word John.

If anyone can help, I would really appreciate it.

 

[Andy B]

Hi

Try this:
=SUMIF(A1:A6,"*John*",B1:B6)

 

[Frank Kabel]

Hi
try
=SUMIF(A:A,"*John*",B:B)

 

[George Lob]

Thank you both for the help. I was not aware that you could use wildcards in
quotes.