Group Expense Splitting into couples

[stacer12219]

Hey everyone, I needed some help figuring out if its possible to split this group expense formate into couples. I managed to do so myself but it gets tricky since one of the group expenses 1 our of 4 is not liable to pay so how can this formula work correctly in this type of situation? for example if Chris paid for a hotel $300 but only 3 out of the 4 will need to pay they would owe him $100 now if he also paid for a car rental that is $400 split x 4 everyone owes $100each so the other couple should owe Chris $300. the current formula does not show that.

[shg]

See the workbook at https://app.box.com/files/0/s/owes/1/f_572584300

[stacer12219]

See the workbook at https://app.box.com/files/0/s/owes/1/f_572584300

? it takes me to a page to sign up. not sure what this is

[shg]

You don't need to sign up for anything, pay anything, provide any personal information, deed your first-born child, nada.

Just press the Download button.

[stacer12219]

You don't need to sign up for anything, pay anything, provide any personal information, deed your first-born child, nada.

Just press the Download button.

Screen Shot 2017-05-01 at 7.59.30 PM.png

Tried it but says page does not exist now =(

[shg]

Try this one:

https://app.box.com/shared/7vb4giq2x7