In cell K5 use the DCOUNTA function to count the StudentID f

In cell K5, use the DCOUNTA function to count the StudentID field in the Student_Data table that meets the filter criteria in the range D1:K2

Solution

DCOUNTA function in Excel count records in a database table that match criteria that you specify.

   where database is a range reference to the Excel table that holds the value that you want to count, field tells Excel which column in the database to count, and criteria is a range reference that identifies the fields and values used to define your selection criteria.

For the given problem use DCOUNTA in cell K5,

DCOUNTA =dcounta(A1:J9,\"StudentID\",D1:K2)

it gives 9 if the fields are non-empty.