Trying to add numbers when grouped together.

[jwillits]

I am trying to add the numbers in column 1 together into column 3 when the numbers in column 2 are the same, however, only when they are touching or directly beneath/above each other. If that same number comes again down the line, I would like it treated as a new number. It is possible that column 2 may have up to 7 of the same number in a row. Any ideas?

100	1	400
300	1
200	2	200
50	3	50
80	1	80
70	2	150
30	2
50	2
40	7	40
120	3	120

I would like column 3 to be a formula to do this.

 

[Eric W]

Try:

Book2
	A	B	C
1	Amt	Code	Sum
2	100	1	400
3	300	1
4	200	2	200
5	50	3	50
6	80	1	80
7	70	2	150
8	30	2
9	50	2
10	40	7	40
11	120	3	120
12
Sheet2

Cell Formulas
Range	Formula
C2:C11	C2	=IF(B2=B1,"",SUM(A2:INDEX(A2:A10,MATCH(TRUE,B3:B10<>B2,0))))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[jwillits]

Try:

Book2
	A	B	C
1	Amt	Code	Sum
2	100	1	400
3	300	1
4	200	2	200
5	50	3	50
6	80	1	80
7	70	2	150
8	30	2
9	50	2
10	40	7	40
11	120	3	120
12
Sheet2

Cell Formulas
Range	Formula
C2:C11	C2	=IF(B2=B1,"",SUM(A2:INDEX(A2:A10,MATCH(TRUE,B3:B10<>B2,0))))
Press CTRL+SHIFT+ENTER to enter array formulas.

Works, thanks!