EXCEL table to find the problem. How do I find the civil service job applicants with college and Han …

Good teachers:
in the table, the college would like to find a single post, would like to find a single Chinese language or find a professional job, how to combine the two, and quickly find it? Your thoughts, please.

find conditions more generally used = SUMPRODUCT function
= SUMPRODUCT ((A1:A10 = “college”) * (B1:B10 = “Chinese language professionals”) menu bar, “data” and then choose the “filter” and then choose “automatic selection”, and then through the drop-down arrow to choose what you're looking for.