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.




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


Thanks