| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Maybe this...
=SUMIF(A1:A10,"party*",B1:B10) or =SUMIF(A1:A10,"*party*",B1:B10) cisse_5 wrote: =sumif("party*",range:range,1) "Dodge" wrote: I would like to use the SUMIF function to add up cells containing common words, but not necessarily the same word, i.e. Cell1 contains party123 value 100 Cell2 contains party 456 value 50 Cell3 contains poser 122 value 100 Cell4 conatins partypooper value 100 Therefore total cells containing "party" = cell 1+cell 2 +cell 4 = 250 Is it possible to do this? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Dynamic sumif function | Excel Worksheet Functions | |||
| Numbers from seperate worksheet to common sheet | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
