Excel: COUNTIF and SUMIF
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: COUNTIF and SUMIF
COUNTIF(range, condition) counts the cells that match; SUMIF(range, condition, sum range) adds the matching rows. Conditions go in quotes: "Food", ">=80", "<>Home".
Key words
- Wildcards
- * any text, ? one character.
- Sum range
- Same size as the range you check.
🔎 What to look for: The condition checks one column; the sum comes from another.
