Creating a balance ledger between several folks

[pcfascist]

I have an excel spread sheet where I have a list of transactions.

Bob paid for bill
Bill paid for bob
James paid for Steve
Steve paid for Bob

I want to create a calculation of whom owes whom money.

I've built the transactions so that that column b is a drop down for who will gain debt and column c will be the person who the debt is owed to.

I now have no idea how to start the list of folks (in column z) to be compaired and totaled.

Thanks for some hints on where to start!

 

[Barrie Davidson]

Use the same range you're using for your dropdown list to populate the names in column Z. To get the amounts owed (or owing), you could use the following formula in column AA and copy down.

=SUMIF(C:C,Z2,D:D)-SUMIF(B:B,Z2,D:D)

Note, this formula assumes the amounts are in column D and you want to calculate the amount owed (or owing) in column AA.

Hope this is helpful.