AVERAGEIF

Basic

Calculate average of cells that meet a condition

Syntax: =AVERAGEIF(range, criteria, [average_range])
Challenge 1
Free
Question:

What is the average order amount for Electronics products?

Dataset:
A B C D E F G
1 Order ID Product Category Region Amount Quantity Date
2 ORD-1001 iPhone 15 Pro Electronics North 1299 1 2025-01-05
3 ORD-1002 Nike Air Max Footwear South 150 2 2025-01-06
4 ORD-1003 Samsung TV 55" Electronics East 899 1 2025-01-07
5 ORD-1004 Office Chair Furniture West 299 3 2025-01-08
6 ORD-1005 MacBook Pro Electronics North 2499 1 2025-01-09
7 ORD-1006 Adidas Sneakers Footwear South 120 1 2025-01-10
8 ORD-1007 Standing Desk Furniture East 599 2 2025-01-11
9 ORD-1008 iPad Air Electronics West 699 1 2025-01-12
10 ORD-1009 Puma Running Shoes Footwear North 95 3 2025-01-13
11 ORD-1010 Bookshelf Furniture South 199 1 2025-01-14
12 ORD-1011 AirPods Pro Electronics East 249 2 2025-01-15
13 ORD-1012 Nike Jordans Footwear West 180 1 2025-01-16
14 ORD-1013 Gaming Chair Furniture North 399 1 2025-01-17
15 ORD-1014 Sony Headphones Electronics South 349 1 2025-01-18
16 ORD-1015 Reebok Trainers Footwear East 85 2 2025-01-19
17 ORD-1016 Coffee Table Furniture West 249 1 2025-01-20
18 ORD-1017 Apple Watch Electronics North 449 1 2025-01-21
19 ORD-1018 Converse Shoes Footwear South 65 4 2025-01-22
20 ORD-1019 Desk Lamp Furniture East 79 3 2025-01-23
21 ORD-1020 Dell Laptop Electronics West 1199 1 2025-01-24
22 ORD-1021 Vans Sneakers Footwear North 75 2 2025-01-25
23 ORD-1022 Sofa 3-Seater Furniture South 899 1 2025-01-26
24 ORD-1023 Canon Camera Electronics East 799 1 2025-01-27
25 ORD-1024 New Balance Footwear West 110 1 2025-01-28
26 ORD-1025 Dining Table Furniture North 699 1 2025-01-29
Challenge 2
Premium
Question:

Calculate the average salary in the IT department.

Dataset:
A B C D E F G
1 Employee ID Name Department Position Salary Bonus Status
2 EMP001 John Anderson Sales Sales Manager 75000 5000 Active
3 EMP002 Sarah Mitchell IT Software Engineer 85000 7000 Active
4 EMP003 Michael Chen Marketing Marketing Lead 70000 4500 Active
5 EMP004 Emily Rodriguez Sales Sales Executive 55000 3000 Active
6 EMP005 David Kim IT DevOps Engineer 90000 8000 Active
7 EMP006 Lisa Thompson HR HR Manager 68000 4000 Active
8 EMP007 James Wilson Finance Financial Analyst 72000 5500 Active
9 EMP008 Maria Garcia Sales Sales Executive 52000 2800 Active
10 EMP009 Robert Taylor IT Senior Developer 95000 9000 Active
11 EMP010 Jennifer Lee Marketing Content Manager 62000 3500 Active
12 EMP011 William Brown Sales Sales Executive 54000 3200 Inactive
13 EMP012 Amanda White IT QA Engineer 70000 5000 Active
14 EMP013 Christopher Davis Finance Accountant 65000 4000 Active
15 EMP014 Jessica Martinez HR Recruiter 58000 3000 Active
16 EMP015 Daniel Johnson Marketing SEO Specialist 60000 3500 Active
17 EMP016 Ashley Miller Sales Sales Manager 78000 6000 Active
18 EMP017 Matthew Moore IT System Admin 75000 5500 Active
19 EMP018 Sophia Anderson Finance Finance Manager 82000 7000 Active
20 EMP019 Joshua Thomas Marketing Brand Manager 68000 4500 Active
21 EMP020 Olivia Jackson HR HR Executive 55000 2500 Active
Premium Challenge

Unlock lifetime access to solve all premium challenges

Unlock Now