stiffrimpet
New Member
- Joined
- Apr 10, 2002
- Messages
- 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
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