🔔 SUBSCRIBE to my channel ➜

Are you interesting in learning how Excel counts items or non items (like empty cells)? Want to learn the various ways of how to count the occurences of a number or text in a range of cells? If you are, you’ve come to the right place to learn from the many examples! There are numerous ways that Excel can count stuff like numbers, words or characters. The various count functions can count up numbers, specific text and even blanks. This video covers the different ways using several count functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) that Excel provides.

#exceltutorial

#doughexcel

📚 I’ve got some Excel Training ➜

🔨 Excel Books & Tech Gear ➜

Nguồn: https://wakeakpsi.com/

Xem thêm bài viết: https://wakeakpsi.com/category/cong-nghe

marry with me

Thank you! Very explanatory and easy to understand!

Super tutorial

Thank you. Short and concise. Very useful!

Very helpful video. But I tried and I face a problem. The count doesn't work for the area I choose. Do you know what is wrong ? In same sheet for different colum it work. But not for the column I want.

Thanks in advance

you would have been a good teacher. To the point, no fancy talk, just the right to the core of the issue.

Thx!

Helped a lot

😍😍😍👍👍👍👍

Thankss😍

thanks a lot…helped me a day before the exam!!

Nice Video

#knowledgeinflow

2019 and still amazingly useful. Thanks.

it's Helpful. Tnx 🙂

I have a spreadsheet where I want to keep track of a number in a lot of cells and how many times the number appears. Also When the number appears i want it to go back to 0 and start the count again until the number pops back up. Can excel do that?

Amazingly easy to learn video🙏

Very helpful and consice. Many thanks!

great

thanks for this tut, really appreciate how easy you made it look

The countifs doesn't work for me when i select the same area for a different criteria. Any suggestions, please? Plus, if I want to use as a criteria sth like and/or how can I do that? Thanks in advance.

Excellent and precise….

Hello;

Thanks for your videos, really interesting, what software do you use to ZOOM IN and OUT?

Respectfully;

Andy

how i count same word in the whole sheet??

thank u very much!! this helps me a lot.. im crying right now.. thanks again

People like you deserve a medal, videos are the best way to learn Excel, I always find it very hard to follow up with tutorials that are only written, but videos allow you to see the actual process of how things need to be done in a fast way, this has helped me a lot, THANK YOU!

thanks sir

This is very helpful! Thanks!

What formula will number cells 1, 2, 3, 4… when Column A = BOB ; and start over at Number 1 when the value in Column A = JOE ; and start over at Number 1 when value in Column A = X (or anything different) ??

Thanks

help full.

I have 1 question

I have a data containing person name and values of them.

now I want to calculate the sum of person name start with any Initial like "A" for first name first alphabet.

can you plz help me with this…?

eg:

ABC. 120

Acb. 100

CAb. 150

BCA. 100

I want to calculate the sum of person who's name start with "A".

Hi I want to count a letter N in a row only if it occurs more than 3 times continuously in a given range of columns. for example if i have N N N X N N X X N X the result should be 3 i.e. N=3 because N occured more than 2 times in continuous combination.

wat if i wanna find with names ? in count ifs

Those who disliked the vid, dont understand csc or ict or anything related to subjects like this.

Well explaind. is there also a way to count mix cells (number and text) where the text is the same but the number differs.Thanks.

Thank you so much for this useful tutorial! It is simple and to the point.

Great tutorial bro, i just learn something new 🙂

To the point. Thanks

Very useful, thx!

Good job,works for me!

Hi Doug, Do you know how you can count how many time several different things occur in the same column? So if in one cell I want, say the total of 3 different types of access levels, pretending there are actually10 different levels? 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 a total in one cell of the number of times they finished somewhere between 5th & 10th. Can you help me please?

Exactly what I was looking for. Clear and concise. Thank you.

Really very helping tutorial!!

very simple and really easy to understand good job budy

I wish you showed the formula bar

This is another really brilliant Excel video that I have found today. Informative, concise, and precise, it is everything that I look for in an excellent instructional video!