Ravi Sir's Cards › Excel
Rent Collection Tracker in Excel (card 2 of 2)
Revision card 2 for Rent Collection Tracker in Excel: Total received: =SUM(I6:I9) gives ₹1,69,500; Collection %: =I10/J10 gives 89.2%; Tenants late this month: =COUNTIF(L6:L9,"Late") gives 2. Includes an example data table.
Read card text
What this card says
2 for Rent Collection Tracker in Excel: Total received: =SUM(I6:I9) gives ₹1,69,500
Collection %: =I10/J10 gives 89.2%
Tenants late this month: =COUNTIF(L6:L9,"Late") gives 2. Includes an
Example
data table
Learn this in the lesson: Rent Collection Tracker in Excel: Monthly Rent Received, Pending Dues and Late Tenants