Split or Distribute Bill Between Friends With Formula

[asolopreneur]

James, Roy, Rich, Charles, Julie, Alice, Hector, Vinton, Kiera, and Corey are travelling. They are staying at a flat at 33 USD per day. They all have money but not equal and they are going to pay in sequence as mentioned in column. If someone don't have enough money the next person is going to contribute.

They want to schedule all future expenses so they all know when their turn is and how much they need to pay. I've included few samples in excel.

I hope I get answer from this great community.

 

[Jeffrey Mahoney]

This is my take on things:

Unknown

	A	B	C	D	E	F
1	Week	Who is going to Pay	Name	Bill	Contribution	Balance
2	1		James	33	34	1
3	1		Roy	33	50	17
4	1		Rich	33	75	42
5	1		Charles	33	30	-3
6	1		Julie	33	17	-16
7	1		Alice	33	14	-19
8	1		Hector	33	33	0
9	1		Vinton	33	30	-3
10	1		Kiera	33	40	7
11	1		Corey	33	100	67
12	2		James	33	20	-12
13	2		Roy	33	40	24
14	2		Rich	33	10	19
15	2		Charles	33	50	14
16	2		Julie	33	33	-16
17	2		Alice	33	34	-18
18	2		Hector	33	0	-33
19	2		Vinton	33	36	0
20	2		Kiera	33	35	9
21	2		Corey	33	10	44

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula F2 =IF(OR(E2<>"",D2<>""),SUMIFS($E$2:$E2,$C$2:$C2,C2)-SUMIFS($D$2:$D2,$C$2:$C2,C2),0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>