formula to count cells not blanK

  • Thread starter Thread starter pmarques
  • Start date Start date
P

pmarques

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


Thanks
 
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.
 
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:D)
"" not counted try =65536-Countblank(D:D)
 
There is a CountBlank function, and each sheet has 65536 rows, so
=65536-CountBlank(D:D)
should work for you
 
Back
Top