🔔 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.
📚 I’ve got some Excel Training ➜
🔨 Excel Books & Tech Gear ➜
Xem thêm bài viết: https://wakeakpsi.com/category/cong-nghe
44 Replies to “Use the COUNT (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) Functions”
marry with me
Thank you! Very explanatory and easy to understand!
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.
Helped a lot
thanks a lot…helped me a day before the exam!!
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!
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….
Thanks for your videos, really interesting, what software do you use to ZOOM IN and OUT?
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!
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) ??
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…?
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!
Comments are closed.