Using AVERAGEIF in Excel to Calculate Conditional Averages (With Examples)

Using AVERAGEIF in Excel to Calculate Conditional Averages (With Examples)

AVERAGEIF() is a powerful Excel formula that calculates the average of cells that meet a certain condition. It’s ideal for analyzing grouped data like average marks by subject or average sales by region.

📘 Syntax:

=AVERAGEIF(range, criteria, [average_range])

✅ Example – Average Marks of Boys Only:

=AVERAGEIF(B2:B100, "Male", C2:C100)

This calculates the average marks from C2:C100 where column B has "Male".

🎯 Practical Use Cases:

• Calculate average score for only passed students
• Find average sales for a particular product category
• Average income of employees in a specific department

💡 Pro Tip:

Use named ranges or structured tables to make AVERAGEIF even easier to manage in large datasets.

🧠 Why Use AVERAGEIF:

It simplifies complex filtering and makes reports dynamic. Combine it with dropdowns or slicers for interactive dashboards.

Master Excel formulas like AVERAGEIF step-by-step with ScriptDataInsights. Learn, apply, repeat.