Counting Text as a Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to "Count" a column which has text in it. I'm at a complete
loss. The count and sum formulas ignore text. Can anyone help?
 
Remember that COUNTA will count cells that APPEAR to be empty if they contain
a formula that is returning an empty string or a cell that contains spaces.


COUNTA will also count cells with numbers in them.
 
Fixed...works....thanks!

Gary''s Student said:
Remember that COUNTA will count cells that APPEAR to be empty if they contain
a formula that is returning an empty string or a cell that contains spaces.


COUNTA will also count cells with numbers in them.
Click to expand...
 
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 number of rows with specific text 2
Sumproduct & Count formula 8
Getting Count Formula Working if Column has both number and text 1
count unique elements 4
Counting Individuals not Occurrences in Excel 2007 2
count nonblank cells 3
Access Dcount (multiple criteria) 3
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top