Ravi Sir's Cards › Excel
Clinic Patient Management System in Excel (card 2 of 2)
Revision card 2 for Clinic Patient Management System in Excel: Due from the patient: =G5-H5 gives ₹500; Visits by type: =COUNTIF(Visits!$E$5:$E$300,A5) gives 7; Collected by type: =SUMIFS(Visits!$G$5:$G$300,Visits!$E$5:$E$300,A5) gives ₹3,300. Includes an example data table.
Read card text
What this card says
2 for Clinic Patient Management System in Excel: Due from the patient: =G5-H5 gives ₹500
Visits by type: =COUNTIF(Visits!$E$5:$E$300,A5) gives 7
Collected by type: =SUMIFS(Visits!$G$5:$G$300,Visits!$E$5:$E$300,A5) gives ₹3,300. Includes an
Example
data table
Learn this in the lesson: Clinic Patient Management System in Excel: Patient Register, Visits, Fees, Follow-up Reminders and Receipts