The formula for that is COUNTA . Imagine you have data from row 1 to row 50 in column A, but row 45 is empty.

Use the ROWS function.

=SUM(A:A) to count rows. Why? SUM adds values. COUNT counts them.

Contar Numero De Filas En Excel [exclusive] Now

The formula for that is COUNTA . Imagine you have data from row 1 to row 50 in column A, but row 45 is empty.

Use the ROWS function.

=SUM(A:A) to count rows. Why? SUM adds values. COUNT counts them. contar numero de filas en excel