Excel Count Cells with Text (Cells that Include Text, Only Text and Occurrence of Specific Text)

[@ExcelatWork]

Let Sharyn show you how to count cells in Excel - count cells including text AND values, how to count cells with only text, and how to count the number of times specific text occurs in a range

[@user-sl7xx7rz2o]

Exactly what I was looking for! Thank you!!

[@ExcelatWork]

Glad I could help!

[@albertoteng3851]

Very helpful and easy to understand.

[@ExcelatWork]

Glad it was helpful!

[@joeeydouglas]

Love you Mam, you gave me exact formula which I needed,
Thank you

[@ExcelatWork]

That's fantastic! So glad the video helped!

[@user-sd3nh8tb7x]

Thank you so much, really helpful.

[@ExcelatWork]

You're very welcome!

[@isaacbostic5823]

Great job keeping it simply

[@ExcelatWork]

Thank you!

[@Tahir-Kashmiri]

Thank you for sharing this video, very helpful.
I have large number of rows and the list contains 1000s of employee names and I would like to count them. How do I go about doing that?

[@ExcelatWork]

Hi there! The COUNTA function should help with this! If you're having no luck I'm happy to take a look at the file for you. Please ensure there is no confidential information in the file and send a copy to [e-mail] 😊

[@nigeshvijayarajendran3351]

This was helpful, thank you !

[@ExcelatWork]

Glad it was helpful!

[@palrajselvaraj6830]

Thank you very much madam.

[@level2456]

Thanks for the video. Suppose you have the following text in a cell "ex123 and ex234" and you want to calculate the number of times "ex" appear in that cell. How is it done.

[@ExcelatWork]

Hi there. If the ex is in the same cell it isn't easy in Excel. You could try copying the content of the cell into a new Word document, then place your insertion point at the top of the document, press Ctrl + F to open the 'Navigation' pane. Type ex into the 'Search' box and press ENTER. Word will show a 'Result' below the Search box. This will show how many times the ex was found in the document. I hope this helps.

[@subhasisgangopadhyay8076]

Fantastic video -Kolkata, India

[@ExcelatWork]

Thank you Subhasis! I'm so happy it helped. Hi from Christchurch, New Zealand! 😁

[@shafinamath]

Very useful

[@ExcelatWork]

Thanks a lot

[@user-tc4bq4jt8y]

Thanks it was helpful

[@ExcelatWork]

Glad it helped

[@djamshedbadridinov4454]

"*" this I dont know before. video help me. Thank you.

[@ExcelatWork]

I'm so glad! Thank you!

[@romefradelsan174]

thank you.

[@ExcelatWork]

You're welcome

[@maricelcalico4658]

thank you

[@ExcelatWork]

You're welcome!

[@ddp2049]

Hello, How can I count a column that contains 2 different texts? example "dayoff sickday"and "dayoff"

[@ExcelatWork]

Hi there. The COUNTIFS function would be super helpful for counting 2 different texts.

[@rlink204]

Thanks!

[@ExcelatWork]

You're welcome!

[@danielkunz9043]

Very helpful

[@VictoriaMacklin]

@excelatwork Is it possible to count where there are multiple values in a cell, ie if you had “paid, outstanding” in one cell (I know it wouldn’t make sense in this particular example, but I have a sheet where an action owner sometimes has one name, which is fine, but sometimes 2 or more names against it. I want to count how many actions each person has! Including those shared actions)

[@theholymessageofholyqurant1598]

Thanks from indian occupied kashmir

[@ExcelatWork]

You're welcome!

[@rakitilak]

How to count numbers of "P", L", "A" used in a row using CountIFS. I tried but shows 0.

[@ExcelatWork]

Hi there. If you'd like to send an example of what you're trying to do to [e-mail] I can see if I can help you out 😊

[@rakitilak]

@@ExcelatWork sure

[@user-fw3wq6lr7u]

Wedil