e.g. I am trying to sum up the row of number when a cell in the same row contains text "Ball"
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.