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)

"pmarques" wrote:


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


Thanks


--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=392466