44 Replies to “Use the COUNT (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) Functions”

1. marry with me

2. Thank you! Very explanatory and easy to understand!

3. Super tutorial

4. Thank you. Short and concise. Very useful!

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

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

7. Helped a lot

8. 😍😍😍👍👍👍👍

9. Thankss😍

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

11. Nice Video
    #knowledgeinflow

12. 2019 and still amazingly useful. Thanks.

13. it's Helpful. Tnx 🙂

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

15. Amazingly easy to learn video🙏

16. Very helpful and consice. Many thanks!

17. great

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

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

20. Excellent and precise….

21. Hello;

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

    Respectfully;
    Andy

22. how i count same word in the whole sheet??

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

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

25. thanks sir

26. This is very helpful! Thanks!

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

28. Thanks

29. 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".

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

31. wat if i wanna find with names ? in count ifs

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

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

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

35. Great tutorial bro, i just learn something new 🙂

36. To the point. Thanks

37. Very useful, thx!

38. Good job,works for me!

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

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

41. Really very helping tutorial!!

42. very simple and really easy to understand good job budy

43. I wish you showed the formula bar

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