Sum # in column only if cell contain text

Solved/Closed

xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012 - Sep 11, 2012 at 10:27 AM
xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012 - Sep 17, 2012 at 12:54 PM

Hello,

e.g. I am trying to sum up the row of number when a cell in the same row contains text "Ball"

[Column A]
Red Ball
Blue Ball
Chair
Pencil
Blue Ball

[Column B]
2
3
4
1
2

The resulting formula should output "7".

So far I have gotten "=IF(ISNUMBER(SEARCH("Ball",A1)),TRUE,FALSE). But I don't know how to sum up those specific rows without having to create another formula in another cell. Ideally I would want one cell, one formula.

Sincerely,
xHaxelx

Sum # in column only if cell contain text
Sum if greater than and less than cell value ✓ - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 11, 2012 at 10:30 AM

=SUMIF(A:A,"*Ball",B:B)

xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012
Sep 17, 2012 at 12:54 PM

Thank you!

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Excel - IF function with multiple words

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!