This can be useful in various scenarios, such as data validation, error checking, or report preparation.
The second formula is based on the SUMPRODUCT with the LEN function.
This option is useful when you better treat formulas that return empty strings ("") as empty.
TheCOUNTA functionis designed to count the number of cells in a range that are not empty.
It considers any cell with content, including text, numbers, errors, and formulas, asnon-empty.
If the count is any other number, the formula will return FALSE.
In other words, the result will be TRUEonly when all cells in C5:G5 are empty.
The screen below shows how you’re able to apply the formula above inside theIF function.
The idea here is clearly mark rows where all 5 cells are blank.
Such cells will be considerednon-emptyby the COUNTA function even though they visually appear blank.
If you better treat formulas that return "" as empty, see the SUMPRODUCT options below.
TheSUMPRODUCT functionthen returns the sum of all lengths.
If the combined length is zero, the formula will return TRUE.
Otherwise, the formula will return FALSE.
This is a more robust solution to the empty vs. blank dilemma.
If a cell is truly empty, its length will be zero, and LEN will return zero.
In other words, LEN will treat formulas that return ="" the same as truly empty cells.
If you are checking a range that does not contain formulas, the COUNTA function will work fine.
