Ravi Sir's Cards › Excel
Day-care Management System in Excel (card 2 of 2)
Revision card 2 for Day-care Management System in Excel: Balance: =E5-F5 gives ₹400; Total due: =C5+D5 gives ₹9,400; Paid: =SUMIFS(Payments!$D$5:$D$2000,Payments!$C$5:$C$2000,A5) gives ₹9,000. Includes an example data table.
Read card text
What this card says
2 for Day-care Management System in Excel: Balance: =E5-F5 gives ₹400
Total due: =C5+D5 gives ₹9,400
Paid: =SUMIFS(Payments!$D$5:$D$2000,Payments!$C$5:$C$2000,A5) gives ₹9,000. Includes an
Example
data table
Learn this in the lesson: Day-care Management System in Excel: Children, Daily Attendance, Late Pickup Charges, Monthly Fees and Fee Bill