Forum Discussion
Determine if column is empty
Is there a simple, canonical way using Excel formulas to check if a column is empty? Right now I am selecting the range in the column and using the "SUMIF" function. I would like the criteria to ...
The formula =COUNTA(A1:A100) will return the number of non-blank cells in the range A1:A100. So if this formula returns 0, the range A1:A100 is completely empty.
Warning: a cell containing a formula counts as a non-blank cell, even if that formula returns the empty string "".