blank range

[Guest]

Hi,
is there any way I can determine if all cells in range are blank?
Thanx

alekm

 

[Andy B]

Hi

Have a look at COUNTBLANK()

 

[Dave Peterson]

=counta(a1:c99)

will count all the cells with something in them. This includes formulas that
evaluate to "", too.

=if(counta(a1:c99)=0,"all empty","at least one filled!")