This is a practical application to determine number of times a patient missed appointment. <br /><br />Count Number Of Time Patients Missed Appointments <br />=COUNTIFS($B$2:$B$69,B2,$C$2:$C$69,"NO") <br /><br />Identify Patients Who Missed Appointment Twice <br />=IF(D2>=2,"Missed 2 Appt","") <br /><br />countif, missed appointment, hospital appointment no show,appointment data, <br /><br />
