Excel: several conditions with COUNTIFS, SUMIFS and AVERAGEIFS

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel: several conditions with COUNTIFS, SUMIFS and AVERAGEIFS

COUNTIFS, SUMIFS and AVERAGEIFS check several conditions at once: a row counts only when every pair (range, condition) matches. SUMIFS and AVERAGEIFS start with the range to add or average.

Key words

Pairs
range, condition, range, condition…
All must match
Like AND.

🔎 What to look for: Every range must cover the same rows.

Zero2Hero — Zéro2Héros