This method stops at the first empty cell. If you have blanks in your data, it will give you a wrong answer. Method 2: The Best Formula ( COUNTA ) When people say "contar numero de filas," they usually mean "count rows with data" — ignoring empty cells.

=COUNT(B:B) This ignores text, errors, and empty cells. It only counts numeric values. What if you want to know the physical number of rows in the entire worksheet — empty or not?

Use the ROWS function.