Hello,

I am looking for a function that counts text values. Is possible to count
for example: how many times in the column A appears text value exp.
Telephone? Or the only way to count that is to "tranform" text value into a
code number and then use Countif or some other function?

Thank you very much!

Kindly regards

You can use COUNTIF for that too. Use this if the work Telephone is the only
text in the cells...

=COUNTIF(A:A,"Telephone")

Use this if the word Telephone has other text with it in the cell...

=COUNTIF(A:A,"*Telephone*")

--
Rick (MVP - Excel)


"ekonomija" wrote in message
...
Hello,

I am looking for a function that counts text values. Is possible to count
for example: how many times in the column A appears text value exp.
Telephone? Or the only way to count that is to "tranform" text value into
a
code number and then use Countif or some other function?

Thank you very much!

Kindly regards