How to check for blank cells with formula

[Bob Flanagan]

I have a number of cells in a row that have formulas that return either text
or "". For example:

=IF(FIND(H$1,$A3)>0,H$1,"")

will return the text in H1 if cell A3 contains H1. The above formulas are
in columns E through R for each row of data. Some return text, and some
return "". I want to identify which rows return "" for all cells in that
row in column E through R by putting a formula in column S. Trouble is, I
can't figureout the formula!!! I tried CountA, but it counts cells with ""
as a cell with an entry. Any suggestions?

Bob

 

[T. Valko]

Try something like this:

=COUNTBLANK(E1:R1)=14

Will return TRUE when all cells are blank/empty.

 

[Bob Flanagan]

Many thanks! I was not aware of that function.

Bob

 

[T. Valko]

You're welcome. Thanks for the feedback!