Count filled cells

[teodormircea]

I have a little problem counting filled(numbers,chars, etc) cells
i used |:
subtotal with filters , nothing
i used COUNTA, nothing
i used COUNTIF(range,"*"), nothing
is still counting the blanks

 

[realsaggi]

Yeah, When you export file in excel from database it terminate null value so it count as blank

 

[realsaggi]

Yeah, When you export file in excel from database it terminate null value so it count as blank

 

[Richard Schollar]

I a data base if you have nothing inside in a case it is NULL, well when you export a data base or a table in excel , NULL is blank , but well it isn't

I know what a Null is. If the cell is not blank, then it contains something. Point the following formula at one of these non-blank (Null) cells and report back what the formula returns:

=CODE(LEFT(A1))

amend A1 to whatever is the cell address of the null cell.