How to Count the Occurrences of a Number or Text in a Range in Excel : Using Excel

Subscribe Now:

Watch More:

Counting the occurrences of a number or a text item in a range in Excel is something that you can do by looking at each column individually. Count the occurrences of a number or a text item in a range in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: If you're looking for a powerful spreadsheet creation tool, look no farther than Microsoft Excel. Get tips on Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.

[leifh]

This was incredible. Exactly what I needed, no long obnoxious introduction, no funny business. Thank you for not wasting anyone's time and just showing us how it's done. Thank you!

[JessicaWhiteAustralia]

This is brilliant - so simply explained, even for an Excel newbie like me. Thank you Ted!

[TheGallantTitan]

Thanks for being clear, concise, and to the point! This video is very well done! I hate when people drone on forever to show how "smart" they are.

[neilhess]

Simple and helpful. Exactly what I was looking for. Thank you!

[Detownrebel]

After 2 hours of searching through MS Office and every other possible resource in which some explanations resulted in more math the Newtons Law, I found what I was looking for. Thank You!

[dadarrow]

Thank you for the great and simple explanation! Helped me on a simple spreadsheet problem.

[stevengovern]

Thanks brosef...I've been trying to figure out how to do this all morning.

[Iamtheboobear]

You sir are amazing. Easy to understand and exactly what I needed.

[snip-sniptear]

Thanks! Made keeping track of my TCG Yu-Gi-Oh and Pokemon rarity count in order and easier. I no longer have to count by color mentally and let the Excel do the counting.

[DAC_AMD]

Hello!
I would need to use a formula which reads different characters from a column, counts them after their type, than displays the counted value if it's greater than x.
I don't have experience with this and a help is welcomed.
Thank you.

[SnapTheDifference]

Thanks for this. I am using it to count how many of each product I have sold. One question, if I insert a row into the data field in which the COUNTIF range feeds from, do I have to change the formula every time?

[sidneya.]

Thanks Ted. This is exactly what I needed for my excel sheet!

[oliverhill]

Much appreciated. Thanks your tutorial was very helpful.

[brocky]

This is super helpful. Is it possible to produce the same results if I were to do the same formula on another blank sheet of the same workbook?

[fishfreak]

Thank you, your video helped me determine how many credit card transactions I had vs. ACH, percentage-wise, and how much each is costing me.

[christinaowens]

Super helpful and easy to follow. Thanks!

[dickyrock]

Ted, you just saved me a heap of time. Thank you kindly

[chrismolinarimusic]

Very good! Thank you for your helpful, concise videos.

[dominiczito]

Hi Ted, Do you know how you can count how many time several different things occur? So if in one cell I want, say the total of players from AZ, AK & MO?  My actual problem is I am using ordinals, 5th, 6th, 7th, 8th, 9th & 10th. I want a total of how many times a person has finished 5th-10th. Here is the formula I've used successfully to total the number of times a person finished 1st; =COUNTIF(B7:B41, "1st"). I've got individual cells for when they finish 1st, 2nd, 3rd & 4th and I use the same formula, just change the "1st" to "2nd" etc. Now I want at total in one cell of the number of times they finished somewhere between 5th & 10th. Can you help me please?

[deborahreyes-doc]

Great, simple and easy to follow!!! Thanks so much Ted.