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 be "If a cell is equal to one or more of any character." Then the sum will return greater than zero if there are any cells with text content in them.
What would be the expression to achieve this?
Thank you.
3 Replies
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 "".
