Hello Guys,
I need your support how to build the code properly to fix below problem.
I need to sum the amounts of lines, where "Name" and "ID number" are the same. Below you find an extract of table, normally its much bigger about 500-600 lines.
[TABLE="width: 489"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]ID number[/TD]
[TD]Amount[/TD]
[TD]Ccy[/TD]
[TD]Date[/TD]
[TD]Sum[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD554[/TD]
[TD]AABBCCDD[/TD]
[TD] 4,052.80[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD557[/TD]
[TD]AABBCCDD[/TD]
[TD] 6,543.50[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD558[/TD]
[TD]AABBCCDD[/TD]
[TD] 8,198.08[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]AABBCCDD[/TD]
[TD] 8,967.30[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]AABBCCDD[/TD]
[TD] 5,011.87[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 32,773.55[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABCD[/TD]
[TD] 6,475.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD569[/TD]
[TD]ABCD[/TD]
[TD] 11,100.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 17,575.00[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]AABBCC[/TD]
[TD] 1,554.14[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]AABBCC[/TD]
[TD] 806.22[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 2,360.36[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABCDEF[/TD]
[TD] 340.18[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]ABCDEF[/TD]
[TD] 227.15[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 567.33[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABBCCDDEE[/TD]
[TD] 3,146.53[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABBCCDDEE[/TD]
[TD] 3,146.53[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 6,293.06[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABC1[/TD]
[TD] 6,375.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABC4[/TD]
[TD] 7,312.50[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This column Sum has been done by me.
I would be grateful if you could tell me how should look like proper code.
Thanks!
max
I need your support how to build the code properly to fix below problem.
I need to sum the amounts of lines, where "Name" and "ID number" are the same. Below you find an extract of table, normally its much bigger about 500-600 lines.
[TABLE="width: 489"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]ID number[/TD]
[TD]Amount[/TD]
[TD]Ccy[/TD]
[TD]Date[/TD]
[TD]Sum[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD554[/TD]
[TD]AABBCCDD[/TD]
[TD] 4,052.80[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD557[/TD]
[TD]AABBCCDD[/TD]
[TD] 6,543.50[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD558[/TD]
[TD]AABBCCDD[/TD]
[TD] 8,198.08[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]AABBCCDD[/TD]
[TD] 8,967.30[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]AABBCCDD[/TD]
[TD] 5,011.87[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 32,773.55[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABCD[/TD]
[TD] 6,475.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD569[/TD]
[TD]ABCD[/TD]
[TD] 11,100.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 17,575.00[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]AABBCC[/TD]
[TD] 1,554.14[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]AABBCC[/TD]
[TD] 806.22[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 2,360.36[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABCDEF[/TD]
[TD] 340.18[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD568[/TD]
[TD]ABCDEF[/TD]
[TD] 227.15[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 567.33[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABBCCDDEE[/TD]
[TD] 3,146.53[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABBCCDDEE[/TD]
[TD] 3,146.53[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD] 6,293.06[/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABC1[/TD]
[TD] 6,375.00[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ClientA[/TD]
[TD]MD567[/TD]
[TD]ABC4[/TD]
[TD] 7,312.50[/TD]
[TD]USD[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This column Sum has been done by me.
I would be grateful if you could tell me how should look like proper code.
Thanks!
max