If you want to count the number of cells with an entry, numeric ot text, normally =COUNTA(A:A)
D daddylonglegs Aug 7, 2006 #1 If you want to count the number of cells with an entry, numeric ot text, normally =COUNTA(A:A)
C CLR Aug 7, 2006 #2 COUNTA will also count those cells with non-printing characters, and those with formulas resulting in zero or null, and hyperlinks.......... There are a number of ways to count "occupied" cells in a column,....if you have a specific requirement, post back and let us know. Vaya con Dios, Chuck, CABGx3
COUNTA will also count those cells with non-printing characters, and those with formulas resulting in zero or null, and hyperlinks.......... There are a number of ways to count "occupied" cells in a column,....if you have a specific requirement, post back and let us know. Vaya con Dios, Chuck, CABGx3
