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

Подписаться 504 тыс.

Просмотров 1,9 млн

50% 1

Subscribe Now:
www.youtube.com...
Watch More:
/ ehowtech
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.

Опубликовано:

9 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 306

@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!

@TexasGI47life 16 дней назад

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

@shsalabdali 9 месяцев назад

its 2023 and im watching this video..

@chelarch4161 9 месяцев назад

Same

@vanta9378 8 месяцев назад

It's 2024 and I'm watching this

@andys2972 7 месяцев назад

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

@kyuiti 7 месяцев назад

It's 2024 and I'm watching this video

@shubhamchaturvedi8960 6 месяцев назад

2024

@TheGallantTitan 5 лет назад

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.

@eileenm.1413 Год назад

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

@josephmpululajames-vg4vf 10 месяцев назад

😂❤ I agree with you.

@johnbandman9415 9 дней назад

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!

@JessicaWhiteAustralia 9 лет назад

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

@PlanetaJuegosPC 2 года назад

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

@hiltonallasiw7085 9 месяцев назад

9 years, and now still helpful. Thanks Sir.

@Detownrebel1 8 лет назад

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!

@lhfabiano4644 5 лет назад

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

@stevengovern5847 5 лет назад

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

@samanthaviberg9509 Месяц назад

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

@annawenders4898 Год назад

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

@paulwilkinson5656 3 года назад

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

@izzahzamri2267 7 месяцев назад

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

@snip-sniptear956 3 года назад

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.

@salvadorseekatzrisquez2947 Год назад

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

@HowardCodes 2 года назад

Thanks Ted. Very Helpful.

@Moonlight-xh3wx 9 месяцев назад

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

@phillipwilliams8501 4 месяца назад

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

@KeysOnFire17 2 года назад

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

@PSJamwal 3 года назад

Thank You eHowTech for the video. It helped me.

@riolonghorn 2 года назад

You are the man. Thank you.

@sureshbhattarai4471 3 года назад

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

@edbn24 3 года назад

great video thank you

@josephfatoye6293 6 месяцев назад

Life saving! Thank you very much

@dickyrock1 5 лет назад

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

@tanaydalwadi5165 2 года назад

TOOOOOOOOOOOOO GOOOOOOOOOOOOOOOOOOD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@MirellaWerthmann Год назад

thank you so much ted! this was great!

@enzoselva888 3 года назад

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

@arsenaldailytransfernews 3 года назад

Thanks for the help!

@Persto1208 Год назад

Exactly what I needed. Thank you!

@profvishwaspatil5551 2 года назад

Thank you for saving my life.

@robertsyer 3 года назад

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

@AM-dn4lk 2 года назад

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

@the.epiceye Год назад

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

@lyricswain515 19 дней назад

Nice and simple, thanks

@JasonDevadason 3 года назад

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

@oscarportillo9939 3 года назад

Thank you, Ted.

@lisamarques3674 8 месяцев назад

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

@moja415 2 года назад

This saved me. Thank you Ted!

@KewlGuy98 4 года назад

This video saved my life. Thank you so much

@saritabhatt4686 2 года назад

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

@Kevin_Childress Год назад

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

@SanthoshKumar-xy3zm Год назад

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

@rileypuntney4496 28 дней назад

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.

@dawntwitchett4526 2 месяца назад

Really simple and helpful. Easy to follow ❤

@ridehi8083 Год назад

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

@nathanrumpf5660 4 года назад

Thank you, Ted. You are an excel wizard.

@nurliyanaaqilahbintimohdpa5821 3 года назад

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.

@prosenjitsingha5523 9 месяцев назад

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

@Pezicodes 3 года назад

Thank you very much. God Bless you

@alexanderlaranjeira1875 2 года назад

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

@user-tq9qp5vx8o 2 месяца назад

Thank you that was very helpful

@josephorossi 2 года назад

thank you so much. so helpful.

@RyanIngram Год назад

THANK YOU

@hayderal-sarraf667 Год назад

So much helpful!

@neilhess2518 2 года назад

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

@faj772 10 лет назад

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

@victorthomas8363 Год назад

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

@patriciachavez-reyes618 3 года назад

Ted, you are a great presenter!

@ChukkR89 3 года назад

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

@nancynovooconnor2717 7 лет назад

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

@SBAK4444 2 года назад

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

@lkyhwa 3 года назад

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

@Angel-nf4nt Год назад

This is perfect! Thank you!

@racheldilligaf7238 3 года назад

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

@mnhkl4395 3 года назад

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

@briangatiu8662 4 года назад

VERY HELPFUL

@Madharasan 3 года назад

it really helped me today :) thank you

@tonderaihwarari6318 Год назад

Saved the day

@mohammadelbashir9692 7 месяцев назад

Thank you Sir, you made my life easier

@Martin-bh9oq 2 года назад

Thank you Ted it helped :)

@andrewkurian6681 3 года назад

Dude - that was awesome and easy! Thx!

@aliasgerhabib1866 5 лет назад

This video saved a lot of my time

@mehtabbabar1832 2 года назад

It is a very helpful video. Thanx sir

@msxcapricorn7210 4 года назад

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

@deborahreyes-doc7201 Год назад

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

@yaseenandyounes372 4 года назад

Thanks because I have a test tomorrow

@krutikadhananjayadesai7927 3 года назад

Thank you it was of great help

@parry1 3 года назад

Very useful! thanks :)

@MrRanvijaykumar 9 лет назад

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

@klibecco Год назад

Thanks, Ted.

@awaisajmal2309 2 года назад

Great way to teaching

@BlindZombee 2 года назад

thanks so much, 2014 and still going strong.

@kiirans9009 2 года назад

Thank you soooooo much dear🙏🙏🙏😊

@TheMrjonv 2 года назад

Thank you so much!!

@Iamtheboobear 3 года назад

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

@crystalavila4669 2 года назад

Thank you very much.

@a93282 3 года назад

Very Nice, my problem solve..👍👍

@sidneya.4330 6 лет назад

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

@Shashwata 3 года назад

Me too

@m5ycgxboi250 Год назад

Brilliant, straight forward and simple to follow. 👍

@hemanthakumar.h.n.4382 3 года назад

Thank you sir.. It was very helpful!

@leuoteletamati2936 2 года назад

thank you ted. sincerely, TV5 samoa your happy channel

@jerley2007 5 лет назад

Works perfect, thank you!!.

@goldenoldiesPete 9 лет назад

Thanks Ted, this was exactly what I needed.

@jasonxjia84 3 года назад

Thanks it helps !!

@aircraftelevation1769 6 лет назад

Works fine, and easy to learn, thanks.

@aurafemorales4197 2 года назад

Thank you so much...❤

@bryanmorehouse9378 4 года назад

Excellent! Thanks!