F Fede Querio Jul 19, 2003 #1 I'd like to calculate the number of non-empty cells contained in a specific column, how can I do it? Thanks, Federico
I'd like to calculate the number of non-empty cells contained in a specific column, how can I do it? Thanks, Federico
A Arvi Laanemets Jul 19, 2003 #2 I'd like to calculate the number of non-empty cells contained in a specific column, how can I do it? Thanks, Federico Click to expand... Hi =COUNTIF(A:A."<>") This leavs out cells with functions returning nothing, like IF(condition,value,""), also
I'd like to calculate the number of non-empty cells contained in a specific column, how can I do it? Thanks, Federico Click to expand... Hi =COUNTIF(A:A."<>") This leavs out cells with functions returning nothing, like IF(condition,value,""), also