ExcelBanter - counting non-empty rows in a column

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - counting non-empty rows in a column (https://www.excelbanter.com/excel-programming/272106-counting-non-empty-rows-column.html)

Fede Querio

counting non-empty rows in a column

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico

Arvi Laanemets

counting non-empty rows in a column

On Sat, 19 Jul 2003 17:39:59 +0200, "Fede Querio"
wrote:

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico

Hi

=COUNTIF(A:A."<")

This leavs out cells with functions returning nothing, like
IF(condition,value,""), also

All times are GMT +1. The time now is 08:13 AM.