🧮

Data Analysis Intermediate

Average For One Category

⏱ 5 min ⭐ 150 XP 🔁 3 attempts allowed

What you'll do

Conditional average.

Scenario

Categories are in A2:A101 and prices in B2:B101. In D2 use AVERAGEIF for category "Books".

Ready to try it?

Create a free account and try "Average For One Category" free for 7 days, no card required. Earn 150 XP and track your internship progress.

Already have an account? Sign in