View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barb24 barb24 is offline
external usenet poster
 
Posts: 1
Default 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