Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence
Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence
1. How to find out duplicate/Unique value in excel
2. How to count only Text in Excel
3. How to count only number in excel
4. 12 Examples of Countif based on different criteria
5. How to use countif+Countif in excel
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Playlist Folder-Basic Excel-countifbundleex.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#countifformula #Innozant #countifexcel #uniquevalueexcel
Пікірлер: 230
Sir you are also a unique person with unique things.
@Innozant
26 күн бұрын
Thanks Vishal Ji..keep learning and keep growing
@VishalSingh-bk8mk
26 күн бұрын
Sir want to paste a text book in excel using each colom of the excel. I want to paste each word of the in each colom. please suggest something.
Ap k teach krny ka trika esa hy k lazy se lazy student b Sikh jae,kitna khush ho k or active ho k prhaty hen aap million of thanks 🙏🙏
@Innozant
2 жыл бұрын
Thanks dear for your valuable appreciation.Happy Learning ♥️
Great concept learnt this morning ❤️❤️❤️❤️ Thank you Innozant
Sir jo aap effort kar rhe hai wo great hai. Great concept ! Bahut sikha maine aapse. Thank you sir.
उस एक दीए की क्या खुब वाहवाही होती है। सलाम हैं मेरा उन गुरुओं को, सिर पे जिनके भविष्य को बदलने की जिम्मेवारी होती है। 👏👏👏👏Very great sir
@Innozant
3 жыл бұрын
Thanks Pooja ..God bless you dear🙏❤️
Jo gyan kahi nahi mila ,wo is youtube par mila thank u gurudev
@Innozant
2 ай бұрын
Keep learning
Bahut accha sir aap ka video
Wow Sir ji, Count A se Count ko minus karna maine kabhi socha hi nahi.. dhire dhire acha se samhe aara ha hai . Thanks a lot
I decided that i bring complete transformation in my life through more studies, practice n will keep on practicing more advance excel n technical knowledge. It's promise to me. Great Rajiv Jee, i appreciate ur teaching. Thanks.
@Innozant
Жыл бұрын
Great ..HAVE A WONDERFUL CAREER AHEAD
Sir esh video mai maja aagaya. Countif sai naya shikhnai ko mila. Step to step harchiz ko samja diya aapnai. Aapkai videos very knowledgeable. Aap humsabko etni achi videos bantai dhyanwaad. You are No.1 Tutor.
@Innozant
3 жыл бұрын
Thanks Aswal sahab,I am always there for all of you..
Nice explanation Sir..Thanks for the helpful video 🙏🙏🙏
Great job it helps me alot
Exquisitely taught sir ji..superb❤
Great Sir, Big Thanks for practice questions 👍 and Thanks for being a good mentor and for guiding us on the right path🙏
@Innozant
3 жыл бұрын
Hope you are doing practice on daily basis and learn step by step . Recommend you to Learn Basic Excel playlist ,then sorting ,Adv.Filter ,Whatif analysis then Lookup series as m uploading video in all playlist
@aakankshasrivastava9497
3 жыл бұрын
@@Innozant yes sir I practice on a daily basis👍
Sir you deserve more than 1 like. This is something out of the box I learn Today.
@Innozant
3 жыл бұрын
Thanks Anil for such a valuable feedback.. Really mean a lot to me.Will alway try to deliver awesome content always.🙏❤️
👍🏼Thank you for learning something different
@Innozant
3 жыл бұрын
Thanks Supriya, If you are beginner learner then I recommend you to start from Basic Excel Playlist 1st video onwards. Thanks for showing your interest in learning MIS.
Thanks sir, aap ka Tarika bahut behatar hai
every time i need help related to excel i just come here and every time i get solution thank you sir
Very useful & informative video 👍
Very nice sir 👌 My problems solved, thanks sir
@Innozant
Жыл бұрын
Thanks dear
Very good my friend.
Very useful, Sir!
Great job sir very useful information 👍
bahuttt badhya concept tha sir
Mast sir Ek dam 👌👌👌👌 very helpful video
Hats off sir..........
M loving it guru ji ❤️
Excellent 👌👌
Amaizing sir, salute you.
@Innozant
Жыл бұрын
Thanks dear
THIS MAN DESERVES MORE SUBSRCIBER
@Innozant
Жыл бұрын
Thanks dear.. Really means a lot to me
Superb and always unique video sir and thanks that you have mentioned my name in this video
@Innozant
3 жыл бұрын
Thanks Khan Sahab ..Happy Learning .God bless you dear
Best excel teacher
@Innozant
2 жыл бұрын
Thanks Rajesh Ji❤️
Samaj to bohott aache se aa gye guru ji
@Innozant
2 жыл бұрын
👍♥️
very usefull video sir,please share other advaced video 🙏
Thanks sir
Most useful
@Innozant
3 жыл бұрын
Thanks dear❤️❤️
Thanku sir example mai name dalney ke liye aur countif ke liye.Again good night sir.😊
@Innozant
3 жыл бұрын
Thanks..Good night
Superb....!!
@Innozant
3 жыл бұрын
Thanks Ajinkya.Good Night
Wow Sir ji * is for text and nontext is .. thanks
Awesome
So nice Sir 👍
@Innozant
3 жыл бұрын
thanks sanoj ji
Just wow
Very nice sir
@Innozant
3 жыл бұрын
Thanks Raveeesh Ji
Muje dashboard ek sheet pe amend ho aur dosre sheet par update ho thanks sir
excellent
@Innozant
3 жыл бұрын
thanks
thnx
GOOD
Dear Sir, I have specific problem regarding BOM, e.g. abcd-1, abcd-2, abcd-3. As it is having first word before"-" common. Require counting method before "-" character. And it should count as one. In the BOM there are different type of item are there. It can be bdfg-1, bdfg-2, and so on.
Thnq sir *
@Innozant
3 жыл бұрын
Thanks Gaurav 👍♥️
Sir, you are awesome.
@Innozant
3 жыл бұрын
Thanks Hemant,Hope you may able to understand the topic and enhance your skills bon regular basis.
@hemantgusain1260
3 жыл бұрын
@@Innozant yes Sir, I am able to understand and learning new things daily basis. But sir I have no experience in Mis. Is it possible for me to get a job in Mis without experience because whenever I checked linkedin or other job portal they mostly required experienced person. But in the field of mis I am fresher. But my excel is ok-ok. Please advice.
@Innozant
3 жыл бұрын
There is no isssue either you are fresher or experienced,You may surely got opportunity if you are able to crack interview.Just make good command over Excel and then let know..will help you out
@hemantgusain1260
3 жыл бұрын
@@Innozant thanks you sir for your advice. I will try much harder to be an expert.
@Innozant
3 жыл бұрын
Good ...learn step by step..from basic excel playlist video..then sorting..filter..what if analysis .. Lookup series ..
Useful video sir.. . Can you please make a video on application of correlation & regression in excel ?
@Innozant
3 жыл бұрын
Yes will make correlation covariation standard deviation and others associted topic soon
With you I feel I understand Hindi also 🙏
@Innozant
Жыл бұрын
👍
Hello Sir, How can be update occurance in access similar you have explained in excel like 1, 2, 3
Sir just saw few lectures of your and really understand the concept..How to start from basic excel. Can you show me the path so that I will start from basic
@Innozant
2 жыл бұрын
Thanks Kiran,You may watch a Video Mis learning process (under career guide playlist) Start your learning journey from playlist Basic Excel-The learning begins followed by advanced Excel(step by step video playlist link available in our videos description)
Hi sir, i have one question why did you not use * after real madrid sample? As you use for “the”,”s” etc.
Sir I need a help , Have any option in excel if need subtotal of countif value ?
👍🏻👍🏻👍🏻👍🏻👍🏻
Hi sir, less than and equal to , what criteria will i use? Less than 4 and equal to?
Sir apne Esme tex or number dono ke bare me btaya Lekin Esme ek row me number or tex combine h uske bare me bhi toda bta dete
how to use counta function to autogenerate serial number when filter used ?
Ek baat aapki bohat acchi lagi aur wo ha samjhane ka tarika. Agar ho sake to mera ek question solve kar dejye. Mujhe 2003version mey unique data kø låna ha but without duplicate + ascending order mey.
@Innozant
2 жыл бұрын
Thanks..Haan kr skete hain.sheeet share kriye..will guide you
@SonuRaj-zp8ik
2 жыл бұрын
@@Innozant email id bhejye mei send karta hu
Sir miss your class padna main aur job vala kaam krnaa main bhut fark hai today I realise 😢😢
@Innozant
9 ай бұрын
Practical kaam karna hoga na dear..keep learning
@nehatiwari4978
9 ай бұрын
@@Innozant yes sir
sir.... Conditional formating se duplicate value high light hogi.. count to fir karna padega sir..
Sir please give us a favour that how can we expert in applying formulas properly because it's very difficult to remember them, we often forget it.
Hi sir please clear this issue once.. for example if I'm calling my friend multiple times in a month or in a day for this I just want the unique for my latest call if day and time is also not there I want only unique with the help of countif formula without duplicate
sir what is formula for counting unique value of different cell?
Great Sir 👍 Could help me to count unique, not duplicate data?
@Innozant
3 жыл бұрын
=sumproduct (1/countif(A1:A10,A1:A10)) Use for uniquebcount from a range
Sir, I want to learn advance excel in detail , step by step and in a systematic way and achieve knowledge like your level...my progress is very slow learning in bits and pieces, do you also take the offline or online coaching. Please do reply.?
@Innozant
2 жыл бұрын
Hi Yusuf, Thanks for showing your interest in MIS learning. Yes we are running live/offline classes,You may contact us for more details.Kindly visit our website.
Sir, I have more than five words in cell I need to find out two words of the cell by countif formula does it possible
How to do distinct count with count if s I. E multiple criteria and get distinct count using count ifs please explain
"*" yeh NOT TEXT aise COUNTIF se karne par agar koyi BLANK CELL rehga wo bhi count mein aa jayega... Isliye cells with number dhoondne ke liye COUNT lagana behtar hoga
Sir agar kisi list me koi naam repeated hai aur hame pata karna hai wo naam koun koun se row number me hai to formulae kya lagega
How to count the cells from a range of where the cells having more than (for example) 6 digits in one cell....pls help
sir last bala jo formula app lagaya wo samjh me nehni a rahi he why you are using ""&19000 instead of that direct we can use "19000" thats all
@fermion4945
2 ай бұрын
Yess
Sir jo last option hai not equal to 1900, "" iska matlab sirf 'Not' hota hai na to 'equal to' lagana jaruri nahi hai?.
Countif lgakr text and number ek sath utha sakte???
If I watched this video before, I could crack my interview.
@Innozant
2 жыл бұрын
Ohhh .No issue ab bhi kaunse der hua hai .Start your learning journey now ❤️❤️😊
Sir I have to fetch average of large 2 number out of 3 cell. But condition is student may get absent in one or two exam and thus out of 3 cell one or two or even 3 cell may be marked as "ab" for being absent. So how to put average & large formula without converting text"ab" as "0" in separate cell and then fetch from there .Plz plz resolve and revert. Scenerio is like this Cell A1: ab Cell B1: 5 marks Cell C1: ab Cell D1: in this cell I want average of best two(out of A1, B1, C1)
Dear Sir, we want occurrence based on category
How to use countifs in countifs & sumifs in one Excel sheet to another Excel sheet
nice vedio . but sir please give the saprate excel link for download purpose
@Innozant
Жыл бұрын
Link is broken ..we are working on it..will update soon
How to apply count formula with different sheet ... suppose agar ek sheet pe kuch unique remarks hai to second sheet pe multiple calling remarks hai to first sheet pe kaise apply karu ki mujhe ye pata chal jaye ki kis remark ke kitne count hai ...
Ok if I have the dates from 1st to 30th October but here I want the latest call unique without duplicate with the help of countif formula
Guru ji 10:35 ki timeing pr ap ne ik Question ka Formula lgaya hai (Countif+Countif) to is ka Ana 2 kyu aaya ???
Sir how to count no of cell where time is present!!!! Such as 7:30am, 8:40pm!!!!
Is it possible to match condition (Header match) inside countifs. The moment we change header count value should be changed
@Innozant
3 жыл бұрын
Share excel sheet will see dear
@shaikvalli1414
3 жыл бұрын
I got the formula. Thanks for the response
Sir, if we use countif(range,"*") it counts spaces also.
@Innozant
2 жыл бұрын
Aditi * means jo text nhi ho to number count krega na.
@rahulsharma6
Жыл бұрын
yes Aditi if any cell contains spaces are considered as text, so this formula is counting those cell as well.
Sir mera ek sawal hein Mujhe Saturday and Sunday count karna hein par, condition e hien ki, hamare pass sirf Star date hein , end date nahiiiii, par dono ka count ek sath karna hein Aap madat kar sakte hein
how to select the range if the cells are not in sequence
Sir, please make a video in which all types of spaces remove by only one formula in excel.
@Innozant
3 жыл бұрын
Ok..noted
@Innozant
3 жыл бұрын
🙏👍
Hi..I have query. In my excel I have list of employees who done calls in last six months. Want to see how many has done each month with unique of names. Let's say if call is closed and month is Jun want to see how many employees worked on that month ..how to pull as like as distinct count in if formula
@Innozant
3 жыл бұрын
Share your excel sheet .Will guide you for the same .
@sumenmrg
3 жыл бұрын
@@Innozant will share
Invoice Sir, please solve my problem. Qut- Rate- Disc%- Tax%- Net Amount 3 - 50 - 15% - 1%+ - 128.77
hello sir i want your email to share excel sheet for one formula for my class result analysis..please
@Innozant
2 жыл бұрын
@innozantofficial telegram id
SIR ELECTION DUTY CARD KAISE BANAYE MS EXCEL SE PLESE TELL ME
I have date, Unit and analyst name and I need unit count daily, Weekly and Monthly
i HAVE A FEED BACK DATA BASE, AND I WANT TO REPORT PREPARE FROM THE DATA, PLZ. HELP ME
Sir, If I am using, =IF(B2>0,IF(A2=B2,"TRUE","TRUE"),"") then I am not able to count "TRUE" or "FALSE" using countif() function. Kindly suggest a way to count TRUE or FALSE result
@Innozant
3 жыл бұрын
Rectify your formula as it seems wrong
I have a List of Payments with Customer IDs in 2022 and 2023 date range. How to find count of Customer IDs those have made payment in 01/2022 to 12/2022 and also made in 2023. How to find count of Customer IDs those did not made payment in 01/2022 to 12/2022 and made payments in 2023. How to find count of Customer IDs those did not made payment in 2023 but made payments in 2022. do u have any suggestions
Sir, what is formula for counting unique value of different cell? for example In A1 cell has the text 'teacher' C1 cell has the text 'teacher' E1 Cell has the text 'teacher but In B1, D1 has not the text 'teacher'. how can we use formula for counting A1+C1+E1
@mushk3340
Жыл бұрын
He only knows how to bring results. Don't know how to explain in detail. He's trying to be over smart.
Sir mere pass ak data hei. O data mei bohot company ka details hei.mujhe use ak company mei kitne log kam korte hein , unka salary nikalna hei to keise konu without search filter ak formula botaiye. Please 🙏🏻