Counting rows that have data

[gavinB]

I would like to count the rows that have data in them.
I have used the function
rows(a1:a7) = 7

A
1 x
2 x
3
4 x
5
6 x
7 x

but only data is only is 5.

 

[duane]

=counta(a1:a7

 

[Bob Phillips]

=COUNTIF(A1:A7,"x")