Sum Until A Colored Cell

[Unexpc]

Hi guys
i have a sheet that i have some customers and all customers continuous from the previous. for example customer 1 start from A1 that have customer name and colored and with a color and continue to A62 and a row afterthat that colored with a color that the role of the separator between customers.
i want SUM every customers that have range (start from name customer and end in that colored separate row before next customer name) in simple say, the range of every customer Start from the customer name and end before next customer name, or better say, how sum in range that between two text not specific cell?(because i added cells and this range not have fixed range)...

 

[mart37]

Map3
	A	B							I
1	Customer	Amount							Subtotal
2	A	10
3		20
4		30
5		40
6		50
7		60
8		70							280
9	B	80
10		90
11		100
12		110
13		120
14		130
15		140							770
16	C	150
17		160
18		170
19		180
20		190							850
21
22		1900							1900
Blad1

Cell Formulas
Range	Formula
I2:I20	I2	=IF(OR(ROW(A2)=ROW($A$20),A3<>""),SUM($B$2:INDIRECT("B"&ROW(A2)))-SUM($I$1:I1),"")
B22,I22	B22	=SUM(B2:B21)

 

[Unexpc]

Map3
	A	B							I
1	Customer	Amount							Subtotal
2	A	10
3		20
4		30
5		40
6		50
7		60
8		70							280
9	B	80
10		90
11		100
12		110
13		120
14		130
15		140							770
16	C	150
17		160
18		170
19		180
20		190							850
21
22		1900							1900
Blad1

Cell Formulas
Range	Formula
I2:I20	I2	=IF(OR(ROW(A2)=ROW($A$20),A3<>""),SUM($B$2:INDIRECT("B"&ROW(A2)))-SUM($I$1:I1),"")
B22,I22	B22	=SUM(B2:B21)

i have this sum like this cells (I8,I15,I20) in another sheet that front of customer name (for example costumer A in Cell A1 and sum in front of customer name and next, Customer B in A2 and sum in B2 and...) but in range of sum that added and not stable, you are doing corectly but i want just like this cells I8,I15,I20 in front of customer name that in another sheet...