Thanks:  0
Likes:  0

# Thread: COUNT with text

1. The COUNT function on a range (eg. =COUNTB3:B10)only works with numbers. Is there any way to make it work with text values in the cells?

Excel Help suggests a COUNTIF function but this is only useful with a certain piece of text (eg "apples") but i need it to count any text value.

Cheers

stiffrimpet

2. On 2002-04-18 06:14, stiffrimpet wrote:
The COUNT function on a range (eg. =COUNTB3:B10)only works with numbers. Is there any way to make it work with text values in the cells?

Excel Help suggests a COUNTIF function but this is only useful with a certain piece of text (eg "apples") but i need it to count any text value.

Cheers

stiffrimpet
=COUNTA()

COUNTIF() could be use also

e.g. =COUNTIF(Range,"*") * = any character (wildcard)

3. On 2002-04-18 06:14, stiffrimpet wrote:
The COUNT function on a range (eg. =COUNTB3:B10)only works with numbers. Is there any way to make it work with text values in the cells?

Excel Help suggests a COUNTIF function but this is only useful with a certain piece of text (eg "apples") but i need it to count any text value.

Cheers

stiffrimpet
Try COUNTA.

4. I mean't any character the ISN'T a number

5. look at Counta
Countif

A concise clear example would allow someone to give a more focused suggestion.

6. The formula I have at the moment is:

=COUNT(Sheet1!A3:A200)

The 'A' column is a list of names and so this formula doesnt work as the COUNT function only works with numbers.

Cheers

s=t=i=f=f=r=i=m=p=e=t

7. On 2002-04-18 11:23, stiffrimpet wrote:
The formula I have at the moment is:

=COUNT(Sheet1!A3:A200)

The 'A' column is a list of names and so this formula doesnt work as the COUNT function only works with numbers.

Cheers

s=t=i=f=f=r=i=m=p=e=t
As suggested earlier use...

=COUNTA(Sheet1!A3:A200)

8. thanks alot!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•