How to COUNT numbers of items?

**toplisek** · 02-25-2009, 05:59 AM

I have used function to track numbers of NOT EMPTY FILEDS.

How to count this with this function as I have sample string of random numbers like:
09-400-000004

Numbers will be added on the right.

It shows me still value 0 although I have NOT EMPTY value like: 09-400-000004

**Andy Pope** · 02-25-2009, 06:04 AM

09-400-000004 is not a value as far as excel is concerned, rather it is some text.

try using COUNTA instead of COUNT

**toplisek** · 02-25-2009, 06:06 AM

Is this COUNT of text or STRING of numbers, text...

**Steve R** · 02-25-2009, 06:07 AM

=counta(1:1) counts the number of cells in a range that are not empty.

**DonkeyOte** · 02-25-2009, 06:12 AM

Beware however that COUNTA counts Nulls as non-blank... if your values are the result of formulae and are always text you may find using COUNTIF(A:A,"*?") safer method.