How to Use AVERAGEIF Function in Excel for Conditional Averages

How to Use AVERAGEIF Function in Excel for Conditional Averages

The AVERAGEIF() function helps you calculate the average of cells that meet a specific condition. It's perfect for summarizing data based on categories or thresholds.

🔹 Syntax:

=AVERAGEIF(range, criteria, average_range)

✅ Example:

=AVERAGEIF(A2:A20, "Math", B2:B20)

This will calculate the average of values in B2:B20 where the subject in A2:A20 is "Math".

💡 Use Cases:

• Average sales of a particular product
• Calculate average scores for one subject
• Find average income based on region or gender

✨ Bonus Tip:

You can use wildcards like "*Science" to match any subject ending in "Science".

Follow ScriptDataInsights for more Excel tricks and dashboard tutorials.