I'm trying to SUMIF numbers in one column if text strings in an adjoining column contain specific text. For instance, if Column A contains a series of text string like this:
COLUMN A
A2: some text etc. other text SEARCH-VALUE more text, even more text, etc.
A3: another string SEARCH-VALUE more...