Instruction: Explain how the 'COUNTIF' function works and provide an example of its use.
Context: This question tests the candidate's knowledge of Excel functions for conditional counting, crucial for data analysis and reporting.
easy
medium