ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count cells that contain data (https://www.excelbanter.com/excel-discussion-misc-queries/226733-count-cells-contain-data.html)

Andrea

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.

Gary''s Student

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.


Francis

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.



All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com