Counta

**HNoel33** · 11-14-2013, 01:41 PM

hello and good afternoon
I am trying to count only the cells that have text in them. I tried COUNTA formula because i thought that was the formula that counted non-blank cells only...
am i missing something here?

CONCERNED

HS

**Ron Coderre** · 11-14-2013, 01:48 PM

COUNTA returns the count of all non-blank cells...including cells that contain: Numbers, Text, text-blanks (=""), etc
Try somethng like this to count text cells with one or more characters:

Formula:

Please Login or Register  to view this content.

1) The "?" in the COUNTIF function represents 1 mandatory character.
2) That formula ONLY works for text and numeric text. It ignores numbers.

Does that help?

**Moo the Dog** · 11-14-2013, 01:51 PM

COUNTA will count all cells in a range that are not blank. That means they can have text, numbers, dates, errors, etc. and still be counted. If you truly only want to count cell with TEXT in them (not numbers, dates, etc.), then use something like this:

=SUMPRODUCT(--(ISTEXT(A1:A25)))

*Assumes your range is A1:A25

- Moo

Note: Mine will include blanks that are results of formulas... so might not be what you need? Ron's looks like it would do...