Mutiple Search match count Criteria

[kashifshahzad]

I have two sheets named, "Attendance Register" which contains Student Name, RollNo, Class, and attendance status (Present, Absent, Sick) date wise
Second Sheet "Summary" i want to count whatever date i entered the cell F2, it show go and check in "attendance register sheet" and count how many "present" or " leave" are there on specific date mentioned in top.
Thanks in advance for help. File attached in the link​

https://www.dropbox.com/s/ra050q546g6s0qf/Attendance Summary Test.xlsx?dl=0

 

[kashifshahzad]

Great work!!! Thank you very much

 

[kashifshahzad]

My Probelm solved already.