In Excel can you add cell A2:A10 that only have text

  • Thread starter Thread starter Guest
  • Start date Start date
If you want to count the number of TEXT cells in a range, try this:

=COUNTA(A1:A10)-COUNT(A1:A10)
That subtracts the count of numeric entries from the count of non-blank cells.

Does that help?

••••••••••
Regards,
Ron
 
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

Excel Conditional Formatting 1
Function for summing or counting cells based on a specified fill color 2
count - but exclude counting cells with a formula 4
Count cell A1 only if cell B2 = Yes 2
multipule calculations in a single column 2
use cell text in lookup function 3
Adding recognised Zeros 5
Using a function to count cells based on multiple criteria 1

Back
Top