Excel 2004 Sumif when cell contains a particular string

[GoingUp]

So I have multiple columns of data.

Column F has names, and column G has counts. All counts are greater than one.

The problem is, that column F has permutations of mutiple names. For example: Gobadgrs $, Gobadgrs231, GobadgrsSDKJSDFLK.

I want a formula to sum up all of the cells in column G, where the cell in the same row in F contains Gobadgrs. I'm thinking it should look something like this.

=SUMIF(F2:F200, SOME CONDITIONAL CHECK ,G2:G200)

Any ideas? Thanks! 🙂

 

[NeoV]

=sumif(range of names, criteria, range of counts) - works for me

 

[Ken g6]

If you're looking for a conditional check that won't error when the string is not found, try this:

FIND("Gobadgrs",F1&"Gobadgrs")<=LEN(F1)-LEN("Gobadgrs")+1

That tacks the string onto the end of the searched string, so it's always found; only the position matters.