Summing between known characters #2

**stevemyers** · 03-03-2010, 02:24 PM

I need to add a variation to my initial request.....

Sample data:

A .....B.....C
-----
Bob...1..
Bob...3
Ted....9....4
-----
Ted...3
Bob...4....4
-----
Ted...1
Ted...4
Ted...5
Ted...2....0
-----

I need a formula for Column C that will sum "Bob" items (could be 1, could be 50 rows) in Column A, where there is known "separators", in this case: -----
There could be thousand of such groups so just adding a formula where I want a sum is out of the question. The formula needs to be one I can simply copy down the column to the end of the data. Thanks

**Paul** · 03-03-2010, 02:31 PM

Hi Steve, try this formula in C2 and copied down:

=IF(A3="------",SUMIF($A$2:A2,"Bob",$B$2:B2)-SUM($C$1:C1),"")

Make sure the number of dashes is correct, this example has six.