Statistical - text function (counting)

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
 
R

Rick Rothstein

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

COUNTIF STOPS COUNTING 12
count unique values in one column for a set value in another col. 2
using CountIF function or Array? 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Counting Results of Formulas 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel function - countif 2

Top