COUNT with text

stiffrimpet · Apr 18th, 2002, 07:14 AM

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

Ian Mac · Apr 18th, 2002, 07:17 AM

Quote:

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)

Aladin Akyurek · Apr 18th, 2002, 07:17 AM

Quote:

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.

Ian Mac · Apr 18th, 2002, 07:22 AM

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

Dave Patton · Apr 18th, 2002, 07:23 AM

look at Counta
Countif

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

stiffrimpet · Apr 18th, 2002, 12:23 PM

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

Mark W. · Apr 18th, 2002, 12:25 PM

Quote:

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)

stiffrimpet · Apr 18th, 2002, 12:54 PM

thanks alot!

Apr 18th, 2002, 07:22 AM	#4
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	I mean't any character the ISN'T a number __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 07:14 AM	#1
stiffrimpet New Member Join Date: Apr 2002 Posts: 10	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

Apr 18th, 2002, 07:23 AM	#5
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	look at Counta Countif A concise clear example would allow someone to give a more focused suggestion.

Apr 18th, 2002, 12:23 PM	#6
stiffrimpet New Member Join Date: Apr 2002 Posts: 10	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

Apr 18th, 2002, 12:54 PM	#8
stiffrimpet New Member Join Date: Apr 2002 Posts: 10	thanks alot!