Dear Sir,

I have the following table to be sum up in block as illustrated.

A B C D


Block
Serial No Border Amount Sub total
1 CX2145 LR 250 250
2 CX2146 550
3 CX2147 620
4 CX2148 420
5 CX2149 LR 200 1,790
6 CX2150 650
7 CX2151 210
8 CX2152 LR 140 1,000
9 CX2153 360
10 CX2154 480
11 CX2155 860
12 CX2156 LR 960 2,660


Column B is the block separator "LR" that divides the block to be sum up.

May I know what formula I must input at cell D1 and copy downwards to get
the answers?

Thanks

Low


--
A36B58K641