Excel Formula

[deniseS]

Is there a way to set a formula to calculate how many rows
above (COUNT) with no text or numbers in the column?

 

[Don Guillett]

try

=COUNTBLANK(F3:F9)

 

[Harald Staff]

=COUNTIF(A1:A100,"")