| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| SumIf | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
