Count cells that contain data
 

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

Count cells that contain data
 

=COUNTA(A1:A10)
--
Gary''s Student - gsnu200843


"Andrea" wrote:

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

Count cells that contain data
 

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



"Andrea" wrote:

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