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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count unique values in one column for a set value in another col. 2
using CountIF function or Array? 3
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel function - countif 2
Help with function 2
Counting Results of Formulas 1
How to count a coloum if two conditions are met 5
Count for text 4

Back
Top