🔔 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:

Related Post


  1. 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

  2. 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?

  3. 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.

  4. Hello;

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


  5. 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!

  6. 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) ??

  7. 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…?

    ABC. 120
    Acb. 100
    CAb. 150
    BCA. 100

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

  8. 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.

  9. 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.

  10. 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?

  11. 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.