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

[@leifh1283]

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!

[@shsalabdali]

its 2023 and im watching this video..

[@chelarch4161]

Same

[@vanta9378]

It's 2024 and I'm watching this

[@andys2972]

I feel you bro, I'm watching this right now...

[@kyuiti]

It's 2024 and I'm watching this video

[@shubhamchaturvedi8960]

2024

[@TexasGI47life]

Ten years later, your video is still helping your viewers. Thank you for that.

[@eileenm.1413]

Even though this video is 9 years old, it was simple to understand for this old school broad. Thank you!

[@josephmpululajames-vg4vf]

😂❤ I agree with you.

[@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.

[@Detownrebel1]

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!

[@sarcasmo57]

Thank you for this. My follow up question is how do I get it to count when 2 values that are in separate columns are true? For example Count if the state is NY AND the birth month is 5.

[@PlanetaJuegosPC]

This is the more wholesome boomer ever. how he use fun examples of excel with data from sports players and how he talks about excel and if excel was a sentient being. its so wholesome i love these tutoriales

[@salvadorseekatzrisquez2947]

I was looking for something else. But I learned this. If I knew I had forgotten and was not using it. Very helpful

[@JessicaWhiteAustralia]

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

[@samanthaviberg9509]

Thank you for this short but informative video! Perfect for what I was looking for

[@Moonlight-xh3wx]

Thanks for making this video. The video very clear, short and quick to understand.

[@johnbandman9415]

Thank you for providing this video. As the others have commented, this is extremely helpful. By my having learned how to do this count, this saved me a great deal of time!

[@PSJamwal]

Thank You eHowTech for the video. It helped me.

[@hiltonallasiw7085]

9 years, and now still helpful. Thanks Sir.

[@stevengovern5847]

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

[@lhfabiano4644]

I came for copper and found gold. I often noticed the dollar sign in some formular, but I never understood its function until now. Thanks a lot for this video

[@annawenders4898]

Sir, you just saved me hundreds of hours of mind numbing counting by hand. THANK YOU!

[@izzahzamri2267]

this is the best and the fastest tutorial I've ever seen. Thank you so much

[@alexanderlaranjeira1875]

thanks for getting straight to the point.
youtubers are dragging out their videos too much. teach them please

[@paulwilkinson5656]

Brilliant! Sir, you just saved me many hours of boring work. Thank You.

[@sureshbhattarai4471]

thanks a lot for explaining it in the simplest possible way.

[@phillipwilliams8501]

Perfect, just what I have been looking for, thank you very much

[@Persto1208]

Exactly what I needed. Thank you!

[@KeysOnFire17]

And I was doing manually! You saved me an entire week of work. Thank you!

[@victorthomas8363]

Thank you Ted, it seemed easy to understand and the nicest way that you've explained it👍🏻

[@JasonDevadason]

Exactly what i was looking for. Thank you so much.

[@nathanrumpf5660]

Thank you, Ted. You are an excel wizard.

[@nurliyanaaqilahbintimohdpa5821]

why i2?

[@willahelmpowers4835]

​@@nurliyanaaqilahbintimohdpa5821 He wants it to show the total for the state to check listed in cell i but is searching the f column which is each players birth state.
i2 is AL, by putting i2 there, he can then drag that formula down the J column and it will automatically change the formula on each row like row 3 it will be check for the the total of the state shown in i3, etc.
I didn't need it for that, but am tracking product stock, so have a column N that puts OOS when that rows item is Out of Stock. I just wanted a quick count of how many OOS's there were, since I manually recheck them for accuracy & specifics. So instead of a cell like i2, I put "OOS". =COUNTIF(N4:N811,"OOS") to show the total OOS in column N.

[@snip-sniptear956]

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.

[@prosenjitsingha5523]

Thanks, Ted. It was really good and made my work easier

[@robertsyer]

I'm pretty new to excel. This is so helpful. Thanks Ted!

[@goldenoldiesPete]

Thanks Ted, this was exactly what I needed.

[@lisamarques3674]

Thank you so much!!! This was perfect for what I needed.

[@AM-dn4lk]

Thank you for showing me exactly what I was hoping to do.

[@andrewkurian6681]

Dude - that was awesome and easy! Thx!

[@dawntwitchett4526]

Really simple and helpful. Easy to follow ❤

[@Kevin_Childress]

Thank you so much for making it simple and easy to follow

[@moja415]

This saved me. Thank you Ted!

[@patriciachavez-reyes618]

Ted, you are a great presenter!

[@ChukkR89]

this video just saved me five working hours a week! my employer thanks you!

[@dickyrock1]

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

[@SBAK4444]

Ted, hi, this was wonderfully clear, and very very helpful. Thank you very much sir

[@rileypuntney4496]

For anyone who needs to enter a ## of ## for page numbers or pallets of pallets (in my situation), you can create another rule of =countif(F$2,F2,F2) and drag down. If it doesn't work to drag that cell, go one down and do (F$2, F3, F3). For this example, it'll label the order of each MVP to their respective state. So Wade Boggs is 3/whatever the total was in that list. Hope it helps somebody.

[@level2456]

Thanks a lot for the explanation. I tried the metthod, and it counts the number of cells containing the word. If the text appears twice in one cell, it counts it as one. What is the formula to ensure it is counted twice. Thanks again

[@neilhess2518]

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

[@ridehi8083]

wow, Im so glad I found this. and thank you so much for making this video.!!!!

[@MirellaWerthmann]

thank you so much ted! this was great!

[@KewlGuy98]

This video saved my life. Thank you so much

[@the.epiceye]

DAMN! This video saved my life. Thanks a lot Sir!

[@msxcapricorn7210]

thank you for uploading, its been a while i worked on excel and totally forgot how to do this formula.

[@nancynovooconnor2717]

Wish I had found this half an hour ago! Thank you!

[@cooluniquefinds]

Ted - would that work with the range being a field of text sentences and find out how many occurrences of a word?

[@deborahreyes-doc7201]

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

[@akshaymore377]

Thank you so much, I was working on a count and was not sure how to do that. I saw this and found my answer. 😊 It's always good to learn. Thanks a lot.

[@sidneya.4330]

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

[@Shashwata]

Me too

[@SanthoshKumar-xy3zm]

Thank you very much sir.Well Explained in a simple manner.🙏🙏🙏🙏🙏

[@arsenaldailytransfernews]

Thanks for the help!

[@profvishwaspatil5551]

Thank you for saving my life.

[@mnhkl4395]

Thank you so much, that's exactly what I was looking for :)

[@racheldilligaf7238]

Thanks Ted!! I think I will pass my assessment now!! :)

[@saritabhatt4686]

Thank you so much . your trick has help me to save my time

[@HowardCodes]

Thanks Ted. Very Helpful.

[@lyricswain515]

Nice and simple, thanks

[@Angel-nf4nt]

This is perfect! Thank you!

[@yaseenandyounes372]

Thanks because I have a test tomorrow

[@MrRanvijaykumar]

It was very easy to understand. I used it. Thanks a lot.

[@riolonghorn]

You are the man. Thank you.

[@Madharasan]

it really helped me today :) thank you

[@faj772]

THANK YOU, THANK YOU!!!!!!! THIS SOLVES THE PROBLEM THAT I HAVE HAD FOR MONTHS,

[@MithunSapui]

Sir, after the filter it will be work on visible cells ?

[@BlindZombee]

thanks so much, 2014 and still going strong.

[@Iamtheboobear]

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

[@lkyhwa]

Yes, it's so helpful! Thank you so much!

[@enzoselva888]

Succinct and effective!!!! THANK YOU!!!

[@m5ycgxboi250]

Brilliant, straight forward and simple to follow. 👍

[@aliasgerhabib1866]

This video saved a lot of my time

[@RodneyMadondo]

Thank you that was very helpful

[@josephfatoye6293]

Life saving!
Thank you very much

[@AyessaJoyce]

For some reason the formula does not update automatically unless i drag and drop it every time a new entry is added on my table. Any recommendation on how to deal with that?

[@mohammadelbashir9692]

Thank you Sir, you made my life easier

[@edbn24]

great video thank you

[@josephorossi]

thank you so much. so helpful.

[@aircraftelevation1769]

Works fine, and easy to learn, thanks.

[@Martin-bh9oq]

Thank you Ted it helped :)

[@hemanthakumar.h.n.4382]

Thank you sir.. It was very helpful!

[@ranjithgupta7727]

If we have a book copy pasted in excel and we want to count number of occurrences for a specific word Hho do we do it ?

[@nicoladavis6291]

I was able to use your formula. Thank you very much!

[@krutikadhananjayadesai7927]

Thank you it was of great help

[@dadarrow34]

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

[@Pezicodes]

Thank you very much. God Bless you

[@mehtabbabar1832]

It is a very helpful video. Thanx sir

[@fishfreak911]

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.

[@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?

[@parry1]

Very useful! thanks :)

[@BSPoK]

On point! .. Ted, do you have a channel?!

[@PriyaAmar848]

Would you mind sharing the drive link of excel sheet

[@johnmontemayorjr.9121]

This video solved my problem. Thank you for posting.

[@oscarportillo9939]

Thank you, Ted.

[@blazingstarx1221]

That was a huge help! Thank you

[@ZackZean21]

Thankzz ❤ I really don't know if my laptop messing with me