Find Cells That Contain Specific Text, Then Add Numbers In Adjacent Column

**jessekanclerz** · 05-11-2011, 05:30 PM

I have data in the following format. Double line break signifies a new column.

Text String || Number
c2-ag-1 || 3
c43-ag-4 || 2
c55-ag-1 || 5
c2-ag-3 || 1
c55-ag-2 || 4

How would I write a formula that outputs the following.

If contains:

c2 || 4
c43 || 2
c55 || 9

**day92** · 05-11-2011, 06:32 PM

Dont really follow your example. How does - c2-ag-1 || 3 become -c2 || 4 ?

**jessekanclerz** · 05-12-2011, 04:19 PM

The formula looks for the string of text before the first hyphen, then adds the numbers in column B that contain the same characters.

So there's 2 C2's therefore 3 + 1 = 4

So there's 2 C55's therefore 4 + 5 = 9

So there's 1 C43 therefore = 2