Set up for table to calculate "who owes what to who?"

[djm]

I have a spreadsheet that totals expenses and divides them (unequally
among 4 people...A, B, C, D.......I need a set of formulas that wil
calculate what D owes A (and B) if B owes A (or vice versa) more tha
what C owes B etc etc...I have attached a copy of the spreadsheet..i
is small (39KB)...when I enter a payment/expense, it automatically goe
under B's column but I can split it b/w A and B..or enter the sam
number under A's column and it will move it from "paid by B" to "pai
by A".....it totals all expenses and divides them, laying out who owe
whom...the difficult part is transferring $$$ from D to A (or B) if C'
share of expenses isn't enough....kind of hard to explain but if yo
look at the sample (TR sample) it will be clear....thank you for an
help/suggestions that you may have.....you can reply here, or directl
to me at (e-mail address removed)

Attachment filename: tr sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62413

 

[wohema]

I have created a solution for your qestion.
See attachement.
Who owes what if conform due payments overall divide

Attachment filename: whooweswho.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62862