Can any help with the function to count non blank cells in a column. Thanks Mario
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<>""))
M Mark Graesser Dec 22, 2003 #3 Mario, Excel has a function for this: =COUNTA(A:A) Good Luck, Mark Graesser [email protected] ----- 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 [email protected] ----- Mario wrote: ----- Can any help with the function to count non blank cells in a column. Thanks Mario
