Excel: counting with COUNT, COUNTA and COUNTBLANK
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: counting with COUNT, COUNTA and COUNTBLANK
COUNT counts cells with numbers, COUNTA counts every cell that isn't empty (text too), and COUNTBLANK counts the empty ones.
Key words
- COUNT
- Numbers only.
- COUNTA
- Anything that isn't empty.
🔎 What to look for: Pick the counter that matches what's in the cells.
