𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee  Department  Salary 
John  IT 75,000 
Sarah  HR 60,000 
Mike  IT 82,000 
David  IT 78,000 
Alice   HR 65,000

How would you count the number of employees in the IT department?

𝗠𝗲: Challenge accepted! 💪

=COUNTIF(B2:B6,"IT")

💡 Explanation: 
The COUNTIF() function counts the number of cells that meet a specific condition. 

• B2:B6 is the range containing department names.
• "IT" is the condition (criteria).
• Excel counts all rows where the department is IT.

This challenge tests your understanding of: 
✅ COUNTIF() 
✅ Conditional Counting 
✅ Data Analysis

🎯 Expected Output Example 
Formula Result 
=COUNTIF(B2:B6,"IT") -> 3 
(John, Mike, and David belong to the IT department.)

🚀 Bonus (Using a Cell Reference as Criteria) 
=COUNTIF(B2:B6,E2)

If cell E2 contains IT, the formula becomes dynamic and automatically updates when the value in E2 changes.

🚀  COUNTIF() is one of the most commonly used Excel functions. After mastering it, practice: 
• COUNTIFS()
• SUMIF()
• SUMIFS()
• AVERAGEIF()
• AVERAGEIFS()

These functions are essential for reporting, dashboards, and Excel interviews.

❤️ React with ❤️ for more interview challenges!