Count cells that contain data

A

Andrea

Hi, just wondering if you can do a countif type function in Excel to count
only cells in a range that contain data. Thanks.
 
F

Francis

Hi Andrea

To count all cells contain data, use
=COUNTA(A1:A10)

To count cells that contain data which are numbers only, use
=COUNT(A1:A10)

To count cells that contain only text, use
=COUNTIF(A1:A10,"*")
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Top