Using the AVERAGEIF Function in Excel (Single Condition Average)

Using the AVERAGEIF Function in Excel (Single Condition Average)

AVERAGEIF() allows you to calculate the average of values that meet a single condition. Perfect when you want insights from filtered data.

🔹 Syntax:

=AVERAGEIF(range, criteria, [average_range])

✅ Example:

=AVERAGEIF(A2:A100, "HR", B2:B100)

This finds the average score of all employees in the “HR” department.

📊 Practical Uses:

• Calculate average sales in a specific region
• Find average marks for students in a subject
• Average monthly expenses of a specific category

💡 Bonus Insight:

AVERAGEIF is great when paired with dropdown filters or dashboards. It's a light yet powerful tool for quick summary metrics.

Want daily Excel tips like this? Follow ScriptDataInsights and upgrade your data analysis skills step by step.