Formula for group spending!

[alkowals]

Good Morning everybody!

I need your help
I would like to figure out a formula to calculate automatically what people owe to each other when they travel together and share expenses. I have been travelling a lot so that would be very helpful!

here is how i start:
name spent owe
lisa 350 -84.2
patrick 59 206.8
julie 58 207.8
amy 49 216.8
jo 750 -484.2
alex 46 219.8
tony 278 -12.2
emilie 5 260.8
total 1595
average 265.8333333

I would like to figure out a way to know automatically that patrick owes 84.2 to lisa and 122 to jo and so on...(knowing that everybody should pay the same amount)
PLEASE tell me you are a guru of excel and you can help me thanks a lot for any tips anyway
Alex

[boopathiraja]

Does average is correct ? based on the listing it should have been 199.375 ? Else provide the arithmetic behind it

[alkowals]

shameful sorry! I have not updated the formula when adding the lines. yes average is 199.375