How to Use the AVERAGEIF and AVERAGEIFS Functions in Excel

How to Use the AVERAGEIF and AVERAGEIFS Functions in Excel

Want to calculate the average of only specific data points in Excel? That’s where AVERAGEIF and AVERAGEIFS come in.

🔹 1. AVERAGEIF (Single Condition)

Formula:

=AVERAGEIF(A2:A10, ">70", B2:B10)

This averages the values in B2:B10 where A2:A10 is greater than 70.

🔹 2. AVERAGEIFS (Multiple Conditions)

Formula:

=AVERAGEIFS(C2:C10, A2:A10, "Male", B2:B10, ">60")

This averages values in C2:C10 where A2:A10 = “Male” and B2:B10 > 60.

🔹 Use Cases:

• AVERAGEIF – When you have one condition (e.g., average marks of students scoring above 70).
• AVERAGEIFS – When you need multiple filters (e.g., average salary of female employees in a department).

✅ Tips:

• Make sure the range and average_range are aligned.
• Use wildcards like "*" and "?" in text conditions.

Both these formulas help you analyze data smarter without manually filtering or sorting!

📈 For more Excel wisdom like this, follow ScriptDataInsights – your daily data partner!