Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence

[@Muzammiljamil6]

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]

Thanks dear for your valuable appreciation.Happy Learning ♥️

[@RA-rh5lb]

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

[@VishalSingh-bk8mk]

Sir you are also a unique person with unique things.

[@Innozant]

Thanks Vishal Ji..keep learning and keep growing

[@VishalSingh-bk8mk]

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.

[@ebcy1591]

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

[@yashcreation2405]

every time i need help related to excel i just come here and every time i get solution thank you sir

[@sandeepaswal8944]

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]

Thanks Aswal sahab,I am always there for all of you..

[@Pooja-bd7zm]

उस एक दीए की क्या खुब वाहवाही होती है। सलाम हैं मेरा उन गुरुओं को, सिर पे जिनके भविष्य को बदलने की जिम्मेवारी होती है। 👏👏👏👏Very great sir

[@Innozant]

Thanks Pooja ..God bless you dear🙏❤️

[@PradeepKumar-hd1ty]

Sir jo aap effort kar rhe hai wo great hai. Great concept ! Bahut sikha maine aapse. Thank you sir.

[@RahulGautam-rb8ij]

Jo gyan kahi nahi mila ,wo is youtube par mila thank u gurudev

[@Innozant]

Keep learning

[@vikashkumarpandey7550]

Exquisitely taught sir ji..superb❤

[@anilande4304]

Sir you deserve more than 1 like. This is something out of the box I learn Today.

[@Innozant]

Thanks Anil for such a valuable feedback.. Really mean a lot to me.Will alway try to deliver awesome content always.🙏❤️

[@cricketexpress5378]

THIS MAN DESERVES MORE SUBSRCIBER

[@Innozant]

Thanks dear.. Really means a lot to me

[@abcdeva27]

Very useful & informative video 👍

[@akrantikuta4500]

Thanks sir, aap ka Tarika bahut behatar hai

[@jitenkalam6679]

Great job sir very useful information 👍

[@aakankshasrivastava9497]

Great Sir, Big Thanks for practice questions 👍 and Thanks for being a good mentor and for guiding us on the right path🙏

[@Innozant]

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]

@@Innozant yes sir I practice on a daily basis👍

[@rajeshtamang4408]

Best excel teacher

[@Innozant]

Thanks Rajesh Ji❤️

[@princemjprasanth8954]

Nice explanation Sir..Thanks for the helpful video 🙏🙏🙏

[@zannesarahamed8776]

Very nice sir 👌 My problems solved, thanks sir

[@Innozant]

Thanks dear

[@VikramKumar-du2mw]

Mast sir Ek dam 👌👌👌👌 very helpful video

[@naeemkhan-tm9hx]

Superb and always unique video sir and thanks that you have mentioned my name in this video

[@Innozant]

Thanks Khan Sahab ..Happy Learning .God bless you dear

[@satishojha6240]

Thanku sir example mai name dalney ke liye aur countif ke liye.Again good night sir.😊

[@Innozant]

Thanks..Good night

[@rahulkashyap2704]

Samaj to bohott aache se aa gye guru ji

[@Innozant]

👍♥️

[@rahulkashyap2704]

M loving it guru ji ❤️

[@VikashKumar-mz9cm]

Great concept learnt this morning ❤️❤️❤️❤️ Thank you Innozant

[@supriyayadav8974]

👍🏼Thank you for learning something different

[@Innozant]

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.

[@pintooprasad2174]

Hello Sir, How can be update occurance in access similar you have explained in excel like 1, 2, 3

[@harditrivedi779]

very usefull video sir,please share other advaced video 🙏

[@shahzadsiddiqui5117]

bahuttt badhya concept tha sir

[@RamPrasad-io2kz]

Great job it helps me alot

[@HEALTHwithHOMEO]

Amaizing sir, salute you.

[@Innozant]

Thanks dear

[@sharyarmalik5554]

Sir I have one data set in which I have to compute counts of sample result values (Non Numeric) from 5 different columns against one variable. but unable to find the solution? please guide

[@hirathakur1769]

Bahut accha sir aap ka video

[@ChandanDas-wl2uk]

Hats off sir..........

[@waleedalqubati3849]

With you I feel I understand Hindi also 🙏

[@Innozant]

👍

[@RVASSORTED]

Very useful, Sir!

[@srikrishnakumar5282]

Very good my friend.

[@keithsamanta9704]

Sir I need a help , Have any option in excel if need subtotal of countif value ?

[@akrantikuta4500]

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

[@vakeelsingh4764]

sir.... Conditional formating se duplicate value high light hogi.. count to fir karna padega sir..

[@irfanhassan3074]

Hi sir, i have one question why did you not use * after real madrid sample? As you use for “the”,”s” etc.

[@saketmishra1470]

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

[@kiranvurukuti4843]

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]

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)

[@RA-rh5lb]

Wow Sir ji * is for text and nontext is .. thanks

[@sriksang26]

how to use counta function to autogenerate serial number when filter used ?

[@rahulkashyap2704]

Guru ji 10:35 ki timeing pr ap ne ik Question ka Formula lgaya hai (Countif+Countif) to is ka Ana 2 kyu aaya ???

[@meditationmusic6482]

So nice Sir 👍

[@Innozant]

thanks sanoj ji

[@Jas_preet26]

Countif lgakr text and number ek sath utha sakte???

[@tjr1421]

Sir jo last option hai not equal to 1900, "" iska matlab sirf 'Not' hota hai na to 'equal to' lagana jaruri nahi hai?.

[@hemantgusain1260]

Sir, you are awesome.

[@Innozant]

Thanks Hemant,Hope you may able to understand the topic and enhance your skills bon regular basis.

[@hemantgusain1260]

@@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]

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]

@@Innozant thanks you sir for your advice. I will try much harder to be an expert.

[@Innozant]

Good ...learn step by step..from basic excel playlist video..then sorting..filter..what if analysis .. Lookup series ..

[@shivaellandulavlogs7149]

How to do distinct count with count if s I. E multiple criteria and get distinct count using count ifs please explain

[@sumenmrg]

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]

Share your excel sheet .Will guide you for the same .

[@sumenmrg]

@@Innozant will share

[@satyajitbiswal6162]

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]

Yess

[@mkp581]

Most useful

[@Innozant]

Thanks dear❤️❤️

[@prakashbhaisuthar621]

sir what is formula for counting unique value of different cell?

[@prof.nitinbhoge7634]

hello sir i want your email to share excel sheet for one formula for my class result analysis..please

[@Innozant]

@innozantofficial telegram id

[@jayasri2689]

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

[@irfanhassan3074]

Hi sir, less than and equal to , what criteria will i use? Less than 4 and equal to?

[@ajinkyashinde1778]

Superb....!!

[@Innozant]

Thanks Ajinkya.Good Night

[@devokedevtech2750]

Excellent 👌👌

[@shashim007]

How to count the cells from a range of where the cells having more than (for example) 6 digits in one cell....pls help

[@shaikhanas1881]

Sir ye wale video kha pe mele ga

[@mohdfaraz7877]

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

[@raveeshkumarsingh5338]

Very nice sir

[@Innozant]

Thanks Raveeesh Ji

[@akrantikuta4500]

Muje dashboard ek sheet pe amend ho aur dosre sheet par update ho thanks sir

[@AKASHBANWANSHI-m6g]

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.

[@subho008]

Sir how to count no of cell where time is present!!!! Such as 7:30am, 8:40pm!!!!

[@tejaskhandare7435]

Sir ji ye excel sheet kaha par save hai, drive ke path pr nahi mil rahe hai.kindly help

[@Innozant]

Kisi bhi video ke description me jaake dekhiye ek assignment master folder download link hai wahan saare hi example mil jayenge playlist wise

[@shaikvalli1414]

Is it possible to match condition (Header match) inside countifs. The moment we change header count value should be changed

[@Innozant]

Share excel sheet will see dear

[@shaikvalli1414]

I got the formula. Thanks for the response

[@SonuRaj-zp8ik]

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]

Thanks..Haan kr skete hain.sheeet share kriye..will guide you

[@SonuRaj-zp8ik]

@@Innozant email id bhejye mei send karta hu

[@santoshdengle5024]

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

[@arunjadhav5168]

Thanks sir

[@BISWAJITDas-mo8bl]

i HAVE A FEED BACK DATA BASE, AND I WANT TO REPORT PREPARE FROM THE DATA, PLZ. HELP ME

[@sachuv121]

how to select the range if the cells are not in sequence

[@kiranghadi7088]

Could you help me with VBA coding of of countif

[@Innozant]

Yes VBA series starts soon .meanwhile if you have any query you may ask

[@kiranghadi7088]

@@Innozant I want VBA coding of countif formula

[@kiranghadi7088]

Same formula in VBA coding

[@jk-iz7ow]

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

[@rahulrakshe1988]

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

[@murthyjallu4223]

Dear Sir, we want occurrence based on category

[@darshansingh3701]

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.

[@devokedevtech2750]

Sir unique name hi lane ke liye esme ham if function lga skte h kya? Kyoki if function se jiski value 1 hogi vo hi aayega nhi to "") kar denge

[@Innozant]

=sumproduct (1/countif(A1:A10,A1:A10)) Use for uniquebcount from a range

[@devokedevtech2750]

Thanks

[@rkmndora]

Useful video sir.. . Can you please make a video on application of correlation & regression in excel ?

[@Innozant]

Yes will make correlation covariation standard deviation and others associted topic soon

[@aditiverma2452]

Sir, if we use countif(range,"*") it counts spaces also.

[@Innozant]

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.

[@javedamu]

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)

[@ramanparjapati8778]

Sir ya btna ki count kro kitna bacha k name ka 2nd letter A h is ka kya formula bnga sir btna please

[@priyanshdaga8499]

=COUNTIF(A1:A5, "?a*")

[@hard1035]

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]

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.

[@kanhaiyathakur1876]

Sir, please make a video in which all types of spaces remove by only one formula in excel.

[@Innozant]

Ok..noted

[@Innozant]

🙏👍

[@manoj-rf2xb]

SIR ELECTION DUTY CARD KAISE BANAYE MS EXCEL SE PLESE TELL ME

[@rinkugusain9759]

excellent

[@Innozant]

thanks

[@jayasri2689]

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

[@deepakchauhan4974]

Apne sir bataya isme ki count if me hum * laga ke text count kar sakte hai ek range se, or * laga ke number, lekin sir mera question hai agar us range me koi number ke bich me space hai to wo use count nahi kar pa rha hai, fir aise situation me kya kare,

[@Innozant]

Use bhinas text count krega na..ya bahar trim pass krke dekhiye .kya kehta hai?

[@deepakchauhan4974]

@@Innozant ok i will try to run trim in outer.lekin sayad apne mera question samjha nahi sir , jaise ki agar koi range me text or number dono hai or number 45 ki jagah kahi 4 5 (dono) ke bich space hai to ye use cou t nahi kr rha hai kaam

[@chandandasy2k10]

SIR I HAVE A QUERY THAT IS NAME IS PRESENT IN ROW WISE AND MONTH IS COLUMN WISE.IF I WANT TO SUM SUCH AS JAN TO MAR OF SOME GIVEN NAME WHAT FORMULA I HAVE TO APLLY.

[@Innozant]

Formula ko automatic se hatake manual kar lijiye pehle phir jaise chahen circular reference sum ho jayega

[@chandandasy2k10]

Name: x Month from: jan Month to: mar Total:? Name rowwise hai or month column wise hai.ab mai koi Vi name dunga or month select korunga total dekha degi.nehi ho raha hai.

[@lazyohlazyinstinctiveimpro1899]

Just wow

[@shaileshjadhav4755]

I have date, Unit and analyst name and I need unit count daily, Weekly and Monthly

[@AsifShaikh-sf6dv]

How to use countifs in countifs & sumifs in one Excel sheet to another Excel sheet

[@Mkumar_45]

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 🙏🏻

[@ayeishayadav4940]

Hello sir Please help me to count the students ,who get less than 70 and more than 50 in all subjects

[@Innozant]

Hi Yadav Ji..simple nested if use krke kr skte hain..issue aa raha hai..to aap excel sheet bnake with query explanation @innozantofficial telegram id par share kariye

[@bishtlokesh1297]

Awesome

[@dpgro20]

Sir ek cell me Kai value ko comma (,) lagakr likha ho kaise count karenge. Example-. ( 123,234,4567) iska count 3 hai Please help me sir

[@Innozant]

Separator count kar lenge tab bhi aa jayega

[@maggushammu]

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

[@4jaipurafzal]

How to get maximum duplicate occurrence without manual counting ?

[@Innozant]

Using count if ..