Sep 27 2021 01:46 AM
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.
Sep 27 2021 01:59 AM
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 "".
Sep 27 2021 02:17 AM