counting non-empty rows in a column

F

Fede Querio

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico
 
A

Arvi Laanemets

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico
Click to expand...


Hi

=COUNTIF(A:A."<>")

This leavs out cells with functions returning nothing, like
IF(condition,value,""), also
 
Top