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


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


Thanks


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