Count non blank rows in a certain range/column Excel

Question

I want to count empty (or non-blank) rows in a given column (or range). Example: I have a column which is spaning over 4 cells width, and each cell has either a single ''x'' or is empty. There is up to 100 rows under this column. Here's a picture to clarify:

Answer 1

The COUNTA() function will do that for you. For example:

=COUNTA(A1:A100)

Will return the number of non-blank cells in the range A1:A100