Ravi Sir's Cards › Excel
Flatmate Expense Split in Excel (card 1 of 2)
Revision card 1 for Flatmate Expense Split in Excel: Total share: =SUM(E9:E13) gives ₹15,469.23; Paid: =SUMIF($D$9:$D$13,E$4,$B$9:$B$13) gives ₹27,000; Balance: =E15-E14 gives ₹11,530.77. Includes an example data table.
Read card text
What this card says
1 for Flatmate Expense Split in Excel: Total share: =SUM(E9:E13) gives ₹15,469.23
Paid: =SUMIF($D$9:$D$13,E$4,$B$9:$B$13) gives ₹27,000
Balance: =E15-E14 gives ₹11,530.77. Includes an
Example
data table
Learn this in the lesson: Flatmate Expense Split in Excel: Share Rent by Room Size and Bills by Days Stayed