sumif and contains
 

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

sumif and contains
 

Hi Barbara,

Where you want your total to be enter

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

Hope this helps

Regards,

Gav

"barb24" wrote:

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