M Mario Dec 22, 2003 #1 Can any help with the function to count non blank cells in a column. Thanks Mario
P Peo Sjoblom Dec 22, 2003 #2 =COUNTA(A1:A10000) or if you have formulas returning blanks =SUMPRODUCT(--(A1:A10000<>""))
G Guest Dec 22, 2003 #3 Mario, Excel has a function for this: =COUNTA(A:A) Good Luck, Mark Graesser (e-mail address removed) ----- Mario wrote: ----- Can any help with the function to count non blank cells in a column. Thanks Mario
Mario, Excel has a function for this: =COUNTA(A:A) Good Luck, Mark Graesser (e-mail address removed) ----- Mario wrote: ----- Can any help with the function to count non blank cells in a column. Thanks Mario
