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.

Zero2Hero — Zéro2Héros