View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 99
Default 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