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.
