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!

ContactName	InvoiceAmountDue	LineAmount	TaxAmount
Mr White	37.58	0	0
Mr White	37.58	27.36	2.74
Mr White	37.58	0	0
Mr White	37.58	6.8	0.68
Mr Red	1420.25	0	0
Mr Red	1420.25	1163.94	116.39
Mr Red	1420.25	120.4	12.04
Mr Red	1420.25	6.8	0.68
Mr Green	637.45	0	0
Mr Green	637.45	518.7	51.87
Mr Green	637.45	54	5.4
Mr Green	637.45	6.8	0.68
Mr Yellow	178.01	143.83	14.38
Mr Yellow	178.01	11.2	1.12
Mr Yellow	178.01	6.8	0.68
Mr Blue	65.43	0	0
Mr Blue	65.43	47.88	4.79
Mr Blue	65.43	4.8	0.48
Mr Blue	65.43	6.8	0.68
Mr Purple	318.12	250.8	25.08
Mr Purple	318.12	31.6	3.16
Mr Purple	318.12	6.8	0.68

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[cutepal]

Got it! Thank you!