ExcelBanter - Counting rows in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting rows in a column (https://www.excelbanter.com/excel-discussion-misc-queries/58818-counting-rows-column.html)

Mar

Counting rows in a column

How do I add up the "not blank" cells in a column? I just want to know how
many rows are in a column.

JE McGimpsey

Counting rows in a column

One way:

=COUNTA(A:A)

In article ,
Mar wrote:

How do I add up the "not blank" cells in a column? I just want to know how
many rows are in a column.

Gord Dibben

Counting rows in a column

=COUNTA(A:A)

Gord Dibben Excel MVP

On Mon, 5 Dec 2005 13:11:03 -0800, Mar wrote:

How do I add up the "not blank" cells in a column? I just want to know how
many rows are in a column.

All times are GMT +1. The time now is 05:23 AM.