Excel 2002 : Any Quick Sub Total Formula ?
 

Dear Sir,

May I know is there any formula that I can input at cell B3 and copy
downwards which could sum up the amount that is sorted according to the code
at column C.

I am currently using @sum( ) by code at column C, which is a bit tedious as
the listing is long.

A B C
1 Amount Sub Total Code
2 1,478 BT
3 2,145 3,623 BT
4 3,214 CM
5 1,125 CM
6 2,147 6,486 CM
7 6,211 FT
8 3,214 FT
9 1,100 10,525 FT
10 1,477 HG
11 9,877 11,354 HG
12 6,521 JG6
13 1,002 7,523 JG6
14 2,106 QP1
15 3,214 5,320 QP1
16 9,982 9,982 RT
17 2,877 VT
18 8,711 11,588 VT
19 3,633 XP
20 1,120 XP
21 2,100 XP
22 6,331 13,184 XP
Total 79,585 79,585


Thanks

Low

--
A36B58K641

Excel 2002 : Any Quick Sub Total Formula ?
 

try
in B2 enter
=if(C2<C3,Sumif(C$2:C$22,C2),"")
and copy down

"Mr. Low" wrote:

Dear Sir,

May I know is there any formula that I can input at cell B3 and copy
downwards which could sum up the amount that is sorted according to the code
at column C.

I am currently using @sum( ) by code at column C, which is a bit tedious as
the listing is long.

A B C
1 Amount Sub Total Code
2 1,478 BT
3 2,145 3,623 BT
4 3,214 CM
5 1,125 CM
6 2,147 6,486 CM
7 6,211 FT
8 3,214 FT
9 1,100 10,525 FT
10 1,477 HG
11 9,877 11,354 HG
12 6,521 JG6
13 1,002 7,523 JG6
14 2,106 QP1
15 3,214 5,320 QP1
16 9,982 9,982 RT
17 2,877 VT
18 8,711 11,588 VT
19 3,633 XP
20 1,120 XP
21 2,100 XP
22 6,331 13,184 XP
Total 79,585 79,585


Thanks

Low

--
A36B58K641

Excel 2002 : Any Quick Sub Total Formula ?
 

oops
=if(C2<C3,Sumif(C$2:C$22,C2,A$2:A$22),"")

"bj" wrote:

try
in B2 enter
=if(C2<C3,Sumif(C$2:C$22,C2),"")
and copy down

"Mr. Low" wrote:

Dear Sir,

May I know is there any formula that I can input at cell B3 and copy
downwards which could sum up the amount that is sorted according to the code
at column C.

I am currently using @sum( ) by code at column C, which is a bit tedious as
the listing is long.

A B C
1 Amount Sub Total Code
2 1,478 BT
3 2,145 3,623 BT
4 3,214 CM
5 1,125 CM
6 2,147 6,486 CM
7 6,211 FT
8 3,214 FT
9 1,100 10,525 FT
10 1,477 HG
11 9,877 11,354 HG
12 6,521 JG6
13 1,002 7,523 JG6
14 2,106 QP1
15 3,214 5,320 QP1
16 9,982 9,982 RT
17 2,877 VT
18 8,711 11,588 VT
19 3,633 XP
20 1,120 XP
21 2,100 XP
22 6,331 13,184 XP
Total 79,585 79,585


Thanks

Low

--
A36B58K641

Excel 2002 : Any Quick Sub Total Formula ?
 

Hello bj

Yes, it works wonderfully.

Many Thanks

Low


--
A36B58K641


"bj" wrote:

oops
=if(C2<C3,Sumif(C$2:C$22,C2,A$2:A$22),"")

"bj" wrote:

try
in B2 enter
=if(C2<C3,Sumif(C$2:C$22,C2),"")
and copy down

"Mr. Low" wrote:

Dear Sir,

May I know is there any formula that I can input at cell B3 and copy
downwards which could sum up the amount that is sorted according to the code
at column C.

I am currently using @sum( ) by code at column C, which is a bit tedious as
the listing is long.

A B C
1 Amount Sub Total Code
2 1,478 BT
3 2,145 3,623 BT
4 3,214 CM
5 1,125 CM
6 2,147 6,486 CM
7 6,211 FT
8 3,214 FT
9 1,100 10,525 FT
10 1,477 HG
11 9,877 11,354 HG
12 6,521 JG6
13 1,002 7,523 JG6
14 2,106 QP1
15 3,214 5,320 QP1
16 9,982 9,982 RT
17 2,877 VT
18 8,711 11,588 VT
19 3,633 XP
20 1,120 XP
21 2,100 XP
22 6,331 13,184 XP
Total 79,585 79,585


Thanks

Low

--
A36B58K641