AVERAGEIF

Calculates the average based on one condition.

Syntax

=AVERAGEIF(range,criteria,[average_range])

Example

Employee	Department	Sales
Amit	Sales	85000
Neha	HR	45000
Rahul	Sales	120000
Priya	Sales	95000
Simran	HR	55000

Average Sales for Sales department:

=AVERAGEIF(B2:B6,”Sales”,C2:C6)

Result:

100000

AVERAGEIFS

Calculates the average using multiple conditions.

Syntax

=AVERAGEIFS(average_range,criteria_range1,criteria1,…)

Example:

Calculate average sales for Sales employees with sales above ₹90,000:

=AVERAGEIFS(C2:C6,B2:B6,”Sales”,C2:C6,”>90000″)

Real-World Uses

• Average sales by department
• Average marks by class
• Average salary by location
• Average attendance by group

Practice

Create a department-wise sales analysis using AVERAGEIF and AVERAGEIFS.