Multiple Search 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.

[boopathiraja]

Hi, in C4

Please Login or Register  to view this content.

Drag down & across.

[kashifshahzad]

Great Work!!! Thanks.