formula to count cells not blanK
 

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

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

=65536-COUNTBLANK(D:D)
--
Gary's Student


"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

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

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