Checking whether or not each of the cells in List1 (column A) is blank, and Counting the Blank Cells.


Use either of the following formulas in column B:
Either formula will return the corresponding value from column A only if the cell is not blank.
Use the COUNTBLANK function, as shown in the following formula, to count the number of blank cells in List1: