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