Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering out rows with an empty column A | Excel Discussion (Misc queries) | |||
Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
Counting rows in a column | Excel Discussion (Misc queries) |