Excel 2002: How to sum up in blocks ?
Say headers are in A1 to D2, and data starts in A3.
Enter this in D3:
=IF(B3="LR",SUM($C$3:C3)-SUMIF($B$2:B2,"LR",$D$2:D2),"")
And copy down as needed.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Mr. Low" wrote in message
...
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
|