Statistical - text function (counting)

  • Thread starter Thread starter ekonomija
  • Start date Start date
E

ekonomija

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*")
 
Back
Top