sumif and contains

[barb24]

I would like to sum numbers in one column if the text in another
column contains a certain text. example below.

A B
2 dogcat
3 dogone
4 catother
5 catone
3 himdog
6 dog this

so I would like to sum the numbers which appear on rows where there is
dog in column B.

I have looked on google groups for sumif and contains, but could not
find this type of thing.
Barbara

 

[Gav123]

Hi Barbara,

Where you want your total to be enter

=SUMIF(B1:B100,"*dog*",A1:A100)

Hope this helps

Regards,

Gav