Sumif contains text

[ShanaVT]

I need to write a sumif formula that sums based on whether or not the cells in the range contain specific text. Any help?

 

[VoG]

Like this?

=SUMIF(A1:A10,"*Text*",B1:B10)

 

[jmthompson]

like this?

Excel 2007<table style="background-color: rgb(255, 255, 255); border: 1px solid rgb(166, 170, 182); border-collapse: collapse;" cellpadding="2.5px" rules="all"><colgroup><col style="background-color: rgb(224, 224, 240);" width="25px"><col><col></colgroup><thead><tr style="background-color: rgb(224, 224, 240); text-align: center; color: rgb(22, 17, 32);"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: rgb(22, 17, 32); text-align: center;">1</td><td style="">help</td><td style="text-align: right;">2</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">2</td><td style="">me</td><td style="text-align: right;">8</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">3</td><td style="">get</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">4</td><td style="">out</td><td style="text-align: right;">3</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">5</td><td style="">of</td><td style="text-align: right;">9</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">6</td><td style="">here</td><td style="text-align: right;">6</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">7</td><td style="text-align: right;">
</td><td style="text-align: right;">2</td></tr></tbody></table>

Sheet1​

<table style="border: 2px solid black; border-collapse: collapse; padding: 0.4em; background-color: rgb(255, 255, 255);" cellpadding="2.5px" width="85%" rules="all"><tbody><tr><td style="padding: 6px;">Worksheet Formulas<table style="border: 1px solid rgb(166, 170, 182); text-align: center; background-color: rgb(255, 255, 255); border-collapse: collapse;" cellpadding="2.5px" width="100%" rules="all"><thead><tr style="background-color: rgb(224, 224, 240); color: rgb(22, 17, 32);"><th width="10px">Cell</th><th style="text-align: left; padding-left: 5px;">Formula</th></tr></thead><tbody><tr><th style="background-color: rgb(224, 224, 240); color: rgb(22, 17, 32);" width="10px">B7</th><td style="text-align: left;">=SUMIF(A:A,"=help",B1:B6)</td></tr></tbody></table></td></tr></tbody></table>

 

[ShanaVT]

Thanks! But I need to be able to reference another cell as the text instead of typing the word in each formula.

 

[VoG]

Try like this


=SUMIF(A1:A10,"*"&D1&"*",B1:B10)