In this article you can teach yourself how to deal with blanks within your data.
Many times you may have some blanks in your data. Here are tricks to make your life easier: to check if there are blanks and how many of them. Also you will learn how to use COUNTBLANK Excel function.
Check if there are blanks
First tricks is to check if there are blank cells in the column.
To check if there are blanks in A column just use this formula:
=IF(COUNTBLANK(A1:A12)>0,"THERE ARE BLANK CELLS","EVERYTHING OK")
Count of blanks
Second trick is about the number of blanks.
To count the number of blanks in the column just use COUNTBLANK Excel function. Here is a sample formula:
Thanks to them it is easier to handle banks within your spreadsheet.