Need help building a formula

[cutepal]

Hello,

I have a series of names and values assigned to each of these names. I need to add "all" the values assigned to the same name and post this total in each of the rows.

Please see the example below - I have to add all the values from Line amount and Tax amount for each contact and input the total of these values in all the rows. How can I achieve this? Thank you for your help!
[TABLE="class: grid, width: 428"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]ContactName[/TD]
[TD]InvoiceAmountDue[/TD]
[TD]LineAmount[/TD]
[TD]TaxAmount[/TD]
[/TR]
[TR]
[TD]Mr White[/TD]
[TD]37.58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Mr White[/TD]
[TD]37.58[/TD]
[TD="align: right"]27.36[/TD]
[TD="align: right"]2.74[/TD]
[/TR]
[TR]
[TD]Mr White[/TD]
[TD]37.58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Mr White[/TD]
[TD]37.58[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
[TR]
[TD]Mr Red[/TD]
[TD]1420.25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Mr Red[/TD]
[TD]1420.25[/TD]
[TD="align: right"]1163.94[/TD]
[TD="align: right"]116.39[/TD]
[/TR]
[TR]
[TD]Mr Red[/TD]
[TD]1420.25[/TD]
[TD="align: right"]120.4[/TD]
[TD="align: right"]12.04[/TD]
[/TR]
[TR]
[TD]Mr Red[/TD]
[TD]1420.25[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
[TR]
[TD]Mr Green[/TD]
[TD]637.45[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Mr Green[/TD]
[TD]637.45[/TD]
[TD="align: right"]518.7[/TD]
[TD="align: right"]51.87[/TD]
[/TR]
[TR]
[TD]Mr Green[/TD]
[TD]637.45[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]5.4[/TD]
[/TR]
[TR]
[TD]Mr Green[/TD]
[TD]637.45[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
[TR]
[TD]Mr Yellow[/TD]
[TD]178.01[/TD]
[TD="align: right"]143.83[/TD]
[TD="align: right"]14.38[/TD]
[/TR]
[TR]
[TD]Mr Yellow[/TD]
[TD]178.01[/TD]
[TD="align: right"]11.2[/TD]
[TD="align: right"]1.12[/TD]
[/TR]
[TR]
[TD]Mr Yellow[/TD]
[TD]178.01[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
[TR]
[TD]Mr Blue[/TD]
[TD]65.43[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Mr Blue[/TD]
[TD]65.43[/TD]
[TD="align: right"]47.88[/TD]
[TD="align: right"]4.79[/TD]
[/TR]
[TR]
[TD]Mr Blue[/TD]
[TD]65.43[/TD]
[TD="align: right"]4.8[/TD]
[TD="align: right"]0.48[/TD]
[/TR]
[TR]
[TD]Mr Blue[/TD]
[TD]65.43[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
[TR]
[TD]Mr Purple[/TD]
[TD]318.12[/TD]
[TD="align: right"]250.8[/TD]
[TD="align: right"]25.08[/TD]
[/TR]
[TR]
[TD]Mr Purple[/TD]
[TD]318.12[/TD]
[TD="align: right"]31.6[/TD]
[TD="align: right"]3.16[/TD]
[/TR]
[TR]
[TD]Mr Purple[/TD]
[TD]318.12[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]0.68[/TD]
[/TR]
</tbody>[/TABLE]

 

[cutepal]

Got it! Thank you!