COUNT TEXT DATA WITHOUT COUNTING BLANK ROWS IN EXCEL manishaMarch 09, 2012 FORMULA OF EXCEL : =COUNTA(C6:C9965)