sumif question

[Guest]

I want to sum the values in a column if the text in a different column same
row CONTAINS a certain word. ie the text doesnt have to match exactly just
include that word. Is the anyway to do this?
Cheers,
Steven

 

[Rita Palazzi]

=SUMIF(a5:a10,"*TEXT*",b5:b10)

a5-a10 is text field to measure
b5-b10 is value to add if true

 

[Guest]

I knew there had to be simple solution!
Cheers Rita