Okay, I've got a spreadsheet, and I want to add a column based on if certain text appears in another column.
Sounds simple enough. Just use SUMIF, right?
Here's the problem:
Cell $B960 (I want the column to stay the same when copied, but the row can change) contains a portion of what it needs to look for.
Think of it this way:
The cells you see with letters could be last names. Above are bunch of first and last name combos. I want to add up the impressions, clicks, etc of the Smiths, Jones, Wallaces, etc.
So, my thinking is that the formula would look like this:
The yellow part is the wildcard part, and the green being the cell reference.
That doesn't work!
I'm going nuts trying to figure this out.
Help!
Sounds simple enough. Just use SUMIF, right?
Here's the problem:

Cell $B960 (I want the column to stay the same when copied, but the row can change) contains a portion of what it needs to look for.
Think of it this way:
The cells you see with letters could be last names. Above are bunch of first and last name combos. I want to add up the impressions, clicks, etc of the Smiths, Jones, Wallaces, etc.
So, my thinking is that the formula would look like this:
=SUMIF($B$2:$B$931,"*-"$B960,C$2:C$931)
The yellow part is the wildcard part, and the green being the cell reference.
That doesn't work!
I'm going nuts trying to figure this out.
Help!