Determine if row is blank

[Joseph]

I have a worksheet that gathers information from multiple
other worksheets. I would like to be able to determine
if every cell in a row (or a range) is null. Is there an
easy way to do that?

thanks

 

[macropod]

Hello Joseph,

You count use the COUNTA function. For example:
=COUNTA(D)
would return a count of the rows in Column D that have any data in them,
including nulls.

Cheers

 

[Dave Peterson]

=if(counta(1:1)=0,"all empty","something in it")

or
=if(counta(a1:b99)=0,"empty","not empty")

 

[Joseph]

Thanks for the suggestion. I tried it, but counta counts
my cells with functions as non-blank even if the result
of the equation is blank. But excel showed me the
function countblank() as a cousin to counta and that
works.

thanks.

 

[2rrs]

Do you mean something like this??

= LEN(A1); fill down.
this will return 0 if cell is blank

or

ISBLANK(A1) equals TRUE if blank