Hello iliace,

Yes, I did.

I just like to know if there are some other ways of doing this other than
Pivot Table and Data Sub Total Function.

Kind Regards

Low


--
A36B58K641


"iliace" wrote:

Have you tried using a PivotTable?

On Aug 17, 10:24 am, Mr. Low
wrote:
Dear Sir,

I used Data Subtotal to sum up the batches. It works very well.

Thank you for that tip.

However when I used the formula =IF(A2=A3, "", SUMIF($A$2:$A$24, A2,
$C$2:$C$24)), I could not get the right answer.

I think this formula is only suitable for batches of reference that do not
repeat itself.

Is there any other formulas for this purpose ?

Thanks

Low

--
A36B58K641



"Jim Thomlinson" wrote:
While I personally would use Data - Pivot Table or Data - Subototal to do
what you are asking here is a formula that you can put in column D

=IF(A2=A3, "", SUMIF($A$2:$A$24, A2, $C$2:$C$24))
--
HTH...

Jim Thomlinson

"Mr. Low" wrote:

Dear Sir,

Lets consider the following worksheet:

A B C D
1 Product Invoice Amount Sub Total
2 A491 V4148 222
3 A491 V4149 1410
4 A491 V4150 282 1914
5 C225 V4151 672
6 C225 V4152 1344 2016
7 H247 V4153 118
8 H247 V4154 118
9 H247 V4155 427
10 H247 V4156 1332 1994
11 A491 V4157 120
12 A491 V4158 222
13 A491 V4159 113
14 A491 V4160 222 677
15 H247 V4161 118
16 H247 V4162 180
17 H247 V4163 222 520
18 C225 V4164 444
19 C225 V4165 528
20 C225 V4166 339
21 C225 V4167 1056 2366
22 D208 V4168 528
23 D208 V4169 328
24 D208 V4170 202 1057
25 Total 10544 10544

May I know what formula must I input at cell D2 and copy downward to sum up
identical product in batches as illustrated ?

These product codes repeats itself as I sort it in ascending order according
to its dates.

Thanks

Low

--
A36B58K641- Hide quoted text -

- Show quoted text -