Checking for Missing Data
First, you’ll need to determine how many people are in your dataset (and much missing data you’re dealing with).
I teach you how to use three formulas to scan for missing data:
- =count() tells you how many cells contain numeric data
- =countblank() tells you how many of those cells are empty
- Then, use =sum() to make sure the =count() and =countblank() add up