# Creating a balance ledger between several folks

#### pcfascist

##### New Member
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!

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### Barrie Davidson

##### MrExcel MVP
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.

Replies
0
Views
741
Replies
1
Views
2K
Replies
0
Views
933
Replies
2
Views
6K
Replies
3
Views
402

1,191,690
Messages
5,988,037
Members
440,125
Latest member
vincentchu2369

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back