formula to count cells not blanK

[pmarques]

i need a formula to count cells of collum D, that aren't blank
sorry i'm a beginner


Thanks

 

[Hugh]

Use the COUNTA function. See the Help file


Counta:
Counts the number of cells that are not empty and the values within the
list of arguments. Use COUNTA to count the number of cells that contain
data in a range or array.

 

[Guest]

=65536-COUNTBLANK(D)

 

[Guest]

It depends on whether you want cells with a "" response to be counted or not
(they look blank, but have a formula in them)
"" counted try =counta(D)
"" not counted try =65536-Countblank(D)

 

[Bryan Hessey]

There is a CountBlank function, and each sheet has 65536 rows, so
=65536-CountBlank(D)
should work for you