Count cells that contain data

  • Thread starter Thread starter Andrea
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count with merged cells 2
Excel Need Countifs Formula Help 0
Using a sub string in a COUNTIF 2
Excel Countif cell has diagonal border 6
COUNT function - # of occurences a number appears in all cells 26
Counting Characters in cells 9
Excel Use COUNTIF across a range of cells with formulas 0
Count cells except... 4

Back
Top