Blankety blank

As you saw in Chapter 1, sometimes you may end up with cells containing no data. For example, if someone refuses to answer a question on a survey, or a sensor failed to pick up a reading, or a store was shut for a holiday.

How you deal with these blank cells can have a big effect on your results, so it's important to tread carefully. The first steps are to able to identify whether a cell is blank (using ISBLANK()), and to count how many blanks that you have.

COUNTBLANK accepts a range of cells, and returns the number of blanks in that range.

Some of column G has been made blank.