TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS

[@mounikasharma5946]

Sir you are the best! Everyone in KZbin teaches to promote their course and knowledge and give us brief and leave it to us…But it is very clear from every video of yours that you only want us to learn …Your teaching method makes us feel that we are in actual classroom and teacher is keeping us very attentive …This is what we call teaching and actual teacher👏👏👏

[@Innozant]

Thanks Mounika for your valuable appreciation and Feedback.Finally main jis soch ke saath aaya tha KZbin platform par ye apka comment aaj mujhse sachme acha feel karya hai ki main sahi track par hoon..I am one of the most underrated on KZbin but you recognise,Really means a lot to me,God bless you dear.Have a wonderful career ahead ❤️

[@shwetaasra6086]

Very True

[@sarashafqat7217]

Great information !sir g .countifs and sumifs ki examples krwa dein. ​@@Innozant

[@ManishVerma-gg8xl]

मजा आ गया सर आपके वीडियो से बहुत motivation मिलता है मै पेशे से accountant हु और आपके द्वारा सिखाया गया countif functions को use करके और उसमे कुछ कोर excel की tricks use करके मैने GSTR-2 A की excel file download करके अपनी books की purchase entry को मेच करके देखा result भी excellent आया जिस काम को करने मे पुरा करने मे पुरा 1 दिन लगता था वो अब लगभग 2 घन्टे मे ही हो जाता है 2 घन्टे भी इसलिये लगते है क्युकी मेरी excel sheet को GST PORTAL के हिसाब से formatting करने मे थोड़ा सा समय लग्ता है जबकी formula तो तुरंत लग जाता है इसका क्रेडिट केवल आपको ही जाता है क्युकी आप बहुत अच्छे से किसी भी टोपीक को समझाते हो 🙏🙏🙏🙏

[@mayadharsahoo8854]

Well teaching. Standing my intlect

[@universe1837]

Bht vidoes dkhy smjh ni a rhaa thaa... Best video.. concept clear ho gyaa Thank you so much..

[@Innozant]

❤️👍

[@binduahuja1104]

Your technique of teaching is just awesome. The best thing about you sir you teach because you want people to learn and get benefitted but in many videos people teach just to showcase that they know better. You show a sense of belongings as you want to make our work easier.

[@Innozant]

Thanks Bindu ,Really means a lot to me.Keep learning ❤️..Keep Exploring. Have. A wonderful career ahead dear👍♥️

[@binduahuja1104]

@@Innozant stay blessed and keep rising Thanks for quick response. 🙏🙏

[@cartoonloversop6019]

सर आप की और मेरी चोइस मिलती जुलती है जैसे आपको टी - शर्ट और ऐकसल पसंद हे वैसे मुजे भी Thanks for teach us

[@Innozant]

Thanks..😀

[@dakshkumar873]

Thank you Sir aapne bahut acche se sikhaya mujhe acche se clear hua.

[@Innozant]

Thanks Daksh

[@sawaimalhi8439]

bhot acha concept tha concept dhanewaaad

[@Innozant]

Thanks dear..aapko mehnat krte dekh acha feel hota hai..iska revert jaroor milega aapko

[@sawaimalhi8439]

@@Innozant ji guru ji bs aaap ki batye rate b sahi say chal paon wo he meri liye guru mantar hoga .. Bs aaap ka sath chaye muje

[@thegreatindia753]

Aap bahut achha samjaye h

[@bharathau8085]

Thanks Brother, It is so helpful.

[@ankitakothari3138]

u r amazing sir bahut acche teacher hai aap

[@Innozant]

Thanks Ankita ,God bless You dear

[@technologyjuni1957]

You Beauty sir the one and only in the youtube Mr Innozant ,learn more God bless you outstanding stunning. we learn alot sir before it i watched many vidoes but i didn't find like it so gorgieus....

[@Innozant]

Really means a lot to me

[@aaditalks9368]

Thank you so much Sir

[@hassanshahzad4964]

Sir your way of delivering lecture is very awesome ❤. You are doing a very great job by helping a lot of people.❤

[@Innozant]

Thanks.Keep Learning

[@nasirali4016]

Smart boy love from Pakistan ♥️

[@Innozant]

Thanks Nasir sahab

[@ebcy1591]

I wanted to bring earthquake in my learning through ur teaching. Thanks Rajeev Jee..

[@Innozant]

Thanks dear..Keep exploring

[@shrikantbadge3978]

Revise kar raha hu sir. now excel seems easy compared to one year ago. Thanks to you 🙏. I saw below my comment and your reply which is 8 months old.🙂🙏 There is no teacher like you.

[@Innozant]

Thanks Shrikant.Really means a lot to me..Hope you and your family are fine ,healthy and happy..God bless you mJeeo learning.❤️🙏

[@qaisarshahzad61]

Very good method

[@pahadiblogs]

This is called teaching with feelings .

[@Innozant]

Thanks Naresh Ji.. Really means a lot to me

[@jaidevbhoomiuttarakhand]

So nice explanation for all levels 👏

[@Innozant]

Thanks dear

[@RameshSahu-yn7es]

Bahut achcha lga Apke caunt,caunta,cauntblank,cauntifs Our batana kuch excel me

[@Innozant]

Thanks..Aate rhenge videos dear❤️

[@jayawasthi9527]

Nice sir..

[@hemantgusain1260]

Thanks for teaching different different types of formulas.

[@Innozant]

Thanks Hemant ji

[@AllahDitta-gp5lt]

جزاکم اللّٰہ خیرا کثیرا کثیرا

[@activest_sanatani]

Thankyou sir ❤

[@satishojha6240]

Thanku sir another most most important explanation for count function. Good night sir

[@Innozant]

Thanks Satish ji.. Happy learning dear..Nice to see ,you learn everyday

[@manojkumarsingh3385]

You are Great sir

[@Innozant]

❤💖💖🙏🙏

[@VikramKumar-du2mw]

Awesome sir 👌👌👌

[@bhoopendraraghav9781]

Very nice video sir g.

[@Innozant]

Thanks Bhoopi..u r sincere candidate...good

[@sandeeparora6539]

The bestest best❤

[@soumensaha4426]

Thank you. Pls. Show the details example or another uses.

[@AllahDitta-gp5lt]

Nice sir Thanks u

[@nexgencomputer7961]

sir data analytics ka video pura bnayiye sir, hum apka video ko details se sikh rha hu, very very thankful sir love you 😘

[@Innozant]

👍

[@harjeetsingh2341]

Sir, advance excel k liye apki agar sari playlists complete krne k baad koi course lene ki need hogi? Ya ye more than enough h?

[@aakankshasrivastava9497]

I was waiting for this video..thank u😊

[@Innozant]

Acha Ji,in this video I discussed concept only..Wait for more examples to come.

[@aakankshasrivastava9497]

@@Innozant okk.. sir😊

[@rajatdogra96]

Which of them is least time consuming??

[@mosadiq123]

Thank you sir

[@Innozant]

Thanks

[@rajusharma-fd2bm]

Sir aapka vidio dekh kr bahut kuchh sikha excel me bahut achha explain krte ho ..kya VBA ka series hai kya mujhe nhi mila..

[@Innozant]

Thanks..Abhi VBA series start nhi kiya hai jald krenge

[@rajusharma-fd2bm]

Please sir mai wait kr rha hue!!

[@artiverma5122]

Beautiful 👌🙏

[@Innozant]

Thanks Arti..Gn

[@battlefansshorts8941]

Nice explain sir ❤

[@Innozant]

Thanks Ravi Ji..tc..HV a Great day

[@gauravbhatia7987]

Good sir

[@chandanmondal50]

Nice sir

[@Innozant]

Thanks Chandan ji❤️🙏

[@bishtlokesh1297]

I waiting for your upcoming excel video

[@Innozant]

New video tomorrow.

[@factiamrd]

Sir excel pe billing ka bi bta do ik br

[@JatinKumar-yc1ij]

sir countifs and sumifs me kitne bar criteria range and criteria select kr skte hai. koi limit hai ya unlimited times. please reply sir

[@sandeepaswal8944]

Sir You are Great Teacher. I learnt a lots yours all playlist video. Thank you for your gudidence sir ji.

[@Innozant]

Thanks Sandeep Ji..keep it up

[@sathyanarayana4914]

NICE VEDIO SIR

[@Innozant]

Thanks Sathya🙏❤️

[@gana_waley]

Sir, how to donot count blank cell which contains spaces in cell , using counta

[@rasbihari1909]

Sumif or sumifs ke bare me easy method se sikhiye

[@ManishKumar-ke9bs]

Count function ke upper aur averageifs ke down me jo functions h uske bare me bataye sir 🙏🙏

[@er.rehanmalik2150]

Sir, I need your help. Actually I have a excel sheet of survey done details date wise mentioned in it and I have 11 survey teams. I want to add a formula in an incentive column as like, on same date if a survey engineer surveyed more than 3 surveys then he get 100rs incentive for his 4th survey and then 5th survey and so on. If he did survey 1, 2 or 3 then no incentive given to him. Which function I have to use?

[@Susheelamahawar]

Sir please share or let us know from where we can collect raw data for using multiple formulas of advanced excel.

[@Innozant]

Example sheet is there..kindly download assigment master folder fekm video description

[@MrAbir06]

U r d best sir... But how to remember all the formulas sir ? Plz tell me some tricks

[@Innozant]

hahaha.. apnr aap practice ke saath yaad rhne lgega dear

[@pradeepkumarrai9446]

I have a data set where it has Start Date & End Date. I need to count a number of total cells if my Start Date & End Date is same. What formula i should use to get this answer??

[@NidhiSingh-ru2pl]

Hi Can u explain countifs function using two sheets

[@Innozant]

Hi Nidhi you may follow Excel Maharaj series after finishing basic excel playlist

[@MaryamShakir-hp4yy]

Ap n jese count,countA,count if sekhaya h isi tarha sum,sumif bhi pori vedio uplodd kr den?

[@Innozant]

Saare videos sequence wise upload hain basic excel playlist me

[@MaryamShakir-hp4yy]

Thanks

[@dipakrathod1204]

I am from Gujarat city Bhavnagar

[@saketmishra1470]

Sir main stuck hun ek jagah aapki help chahiye..agar ek column me multiple duplicate words hai aur us har ek duplicate word ka row number chahiye to kya formulae use karenge

[@hasibahsan15]

Good morning. I have a question. How do I count different words from a single column in excel 365.

[@dhakafady774]

sir you wow

[@ramaghav6328]

if i have data in (Apri-21, March-21, June-21) format in a excel shell if i want to count only Apri-21 then how should i count?

[@dipakrathod1204]

Dipak R. Rathod . Good. 59 years old

[@DEviL-sp4uy]

Badia sir

[@Innozant]

Thanks dear

[@SukhveerSingh-dp1qs]

Sir aap jo bhi sikhate hai uska excel sheet bhi video ke saath daale meri aap se request hai

[@Innozant]

Already diya gaya hai excel sheet dear..kindly aap video description me jaake assignment master download karen ..aapko harek playlist ka excel practice sheet mil jayega

[@nikhilranjan171]

Is there any formula to get 'TRUE' if the value in a particular cell is 'greater than or equal to' twice the value in an another cell? Plz rply. Thank You

[@NitinPundir4055]

Sir agar apni koi excel ki problem aapse share krni ho to kese kr skta hu

[@Rahul-rp6qe]

Tahseel sdm office me operator work k liye kis application pr camand achchi honi chahoye h .word ya excl me . Sir please answer zaroor de dijiyga sir please sir plz answer dijiyga.

[@Innozant]

Normal Ms office ki knowledge..ms word aur excel both

[@Rahul-rp6qe]

@@Innozant thank you sir thank u very much sir

[@Rahul-rp6qe]

Sir aapko fir se preshan karne k liy sorry sir . Sir mera ek or question h sir mujhe ye to aapne bata diya word excl aana chahiye lakin sir mujhe excl me kon kon se function pr jada focus karna h .sir mera marg darshan aap hi kr sakte h. Sir plz reply dijiyga mujhe bhi safal hona h life me

[@nilkanthkumar8054]

AB0 CN5 AB1 NL0 NL0 NL1 SA3 count of records which doesn’t contain 0 which formula is fit for this question?

[@shrikantbadge3978]

Waiting for your more videos as you said in this one. Every video is precious and unique.

[@Innozant]

Soon dear..may b today evening 😊

[@deepakchauhan4974]

in download files, there are tota, 14 or 15 files under driver, Is this the complete sets of practice ? Or you have some alternative download files sir,

[@Innozant]

Practice file is there Playlist wise and Video example wise as well.You may find two seprate link in video description

[@deepakchauhan4974]

@@Innozant not sure sir, I got only one link, however you are telling there are two seperate links in for practice in all specific videos. This is the problem , can you please tell me where it is , so that i can find it out. As i can see only one download file sir

[@bishtlokesh1297]

Im not coward sir i am ready 👍

[@Innozant]

This is what I expect

[@basavarajlbandiwad2299]

Sir how to count coloured cell in given range...

[@basavarajlbandiwad2299]

Sir, plz let us know how to count green colored cell in given range of colored cells...

[@afnanforyou]

Sir, yeh question thoda off-topic hain. Kya aap bata sakte hain ki new dynamic arrays like Filter function or Unique function k extracted values ko kaisa Sum kar sakte hain? Suppose hum new filter function use kar k kuch data lekar aaye, wahan ek column amount ka hain aur us column ko humain sum karna hain, to kaisa kar sakte hain?

[@Innozant]

Question explain kijiye ya data share ..waise filtered databko sub krne ke kai approach..using aggregate or subtotal.

[@afnanforyou]

@@Innozant Sir suppose, hum filter function use kar k kuch data extract karte hain and there is an amount column. Ab extracted data table ka size change hote rahega according to the given criteria. How to use the sum function in such a situation?

[@javedallahbadia]

👌👌

[@bikidas615]

Sir .. Countifs me agar 3 to 4 criteria ho..Ek cell k under To kese kare ge..

[@rajeshbisht7743]

Sir how can i remove space count in counta formula.

[@Innozant]

Use substitute instead

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@iamsainipawan]

Sir practice file Ka single link share kijiye rather then complete folder very easy to find out and practice 🙏 otherwise folder ok to find out for practice file 🙏 sir for your guidance 👍

[@Innozant]

Pawan Ji already sabka individual link diya gya tha but somehow broken ho gya hai link..dubara sabka link phirse generate Krna hoga..time dijiye update kr denge kuch din me

[@iamsainipawan]

@@Innozant 🙏sir

[@bishtlokesh1297]

First view😍

[@Innozant]

Thanks Lokesh ji

[@karishmaverma4682]

Sir please help me kisi particular district k ander kitne team members working h kaise check karenge

[@Innozant]

Couunif with criteria use kriye Vermaji.. Maine padhaya hai na😊❤️👍

[@artiverma5122]

Bhut badiya sir, but m practical b krti hu apki vedio k sath, but boolakad hu baar baar bhool jati hu.

[@Innozant]

bhulakkar nhi hain aap..concept ko samjhke apply krna seekhiye..akne aap yaad rhne lagega jab practice Kroge ek hi topic ko kai baar to

[@archanaaa2514]

Sir, some people says dat excel is dead.. Better learning R.. I don't know. Which is most useful for learning?

[@Innozant]

Good Morning Archana,Kindly ask those candidate that in regular office work & mis reporting which application I need to use Excel or R programming? 2nd thing if the person is not from technical background or No interest in programming then what is the use of R programming for those person. 3rd thing tell those person yadi itna hi knowledge hai market ka to phir apka R programming bhi opcilit ho raha hai...Better to learn Python Instead of R programming as it's limited.

[@Innozant]

Excel never dead dear,this application is the basic need of daily office work .If you want to make career in MIS fields start learning Advanced Excel first. There are two way to proceed If you are from Non technical background Advanced Excel+SQL+VBA+TABLEAU or POWER BI if you are from Technical background Advanced Excel+SQL+VBA+R programming or python with data science

[@Innozant]

Kindly watch this video your doubt may clear with this kzbin.info/www/bejne/kF6onYWYr7x_aKs

[@archanaaa2514]

@@Innozant Thank you sir.. Ur information is motivate us..

[@Innozant]

Start your learning Now.Best of luck.

[@ayushiraj2084]

What is there are more than 2 criteria for countifs ? .. i just know know till 2 conditions

[@Innozant]

No issue at all..kindly explain your query or connect us via telegram id @innozantofficial

[@aamirshahzad5020]

How i can download the file for practise for each video

[@Innozant]

Download assignment master folder from videos description

[@Respect2ev1]

Mere pass bahot data usko bhai ek excell sheet me Dashbord bana na hai ...Daily data pase karne par Dashbord auto update ho

[@yogeshpimple2860]

🎉

[@Sandeepkumar-jy5vt]

Sir hame excel ke sare short cut chahiye

[@Innozant]

Seprate chaiye apko .wo upload kr denge

[@firefmmotivation1367]

Dedicated videos

[@ankursrivastava9314]

If I am having multiple data month wise and need month wise unique count, how do we get?

[@Innozant]

First we need to identify and segregate month and bases on that find out unique value, ok will add this in upcoming tips nd tricks videos

[@johnmrvl3]

Dear tell me . I have big data . I need to separate age gender doses . Age 10 to 40 . 40 to60 . And 60 to 100 age factor in this age factors some are male and female and 1st 2nd doses

[@jayshreedave4004]

Builder mahesh ramesh aise kitane naam hai woh kaise count kare?

[@mehakmaini9243]

Sir, i was using countifs function. My condition was that i have to count the number of employees from south region and from Hyderabad branch earning more than 30000 rupees. I applied the formula and it gave me the result 4. While in reality there are 6 employees as such when i count them. Why is it so sir?

[@Innozant]

Dear Mehak,Kindlh show me your formula how you pass it or better you may WhatsApp screen shot..with formula .Will guide you for the same.

[@mehakmaini9243]

@@Innozant sir i sent that query some days before

[@Innozant]

@@mehakmaini9243 Whatsapp or mail?

[@mehakmaini9243]

@@Innozant sir WhatsApp

[@poojarisrinivasulu7693]

Good morning sir How to count duplicate

[@Innozant]

Number of ways to count duplicate value in excel,You may find our video for the same in YT channel

[@bishtlokesh1297]

I have knowledge all formula but i want different different types uses of every formula

[@Innozant]

Have patience..Thak jaoge aap lekin conceptual video aate rhenge humesha..so be ready 😊👍

[@sapnagusain5277]

Sir laptop par kaise freez hota hai please help..

[@Innozant]

Good Morning Sapna. Function key(Fn) ke saath F4 press karna laptop me

[@sapnagusain5277]

@@Innozant ok sir thank you

[@vivekkumar-rv3fo]

Sir ji, meri prblm ka solution karo. COUNTA FORMULA US CELL KO BHI COUNT KAR RAHA H JISME FORMULA LIKHA HUA H AUR US FORMULA KA RESULT BLANK H, JABKI COUNTBLANK FORMULA BHI US CELL KO COUNT KAR RAHA HAI.

[@muneshpal2951]

Sir ham chahte h ki agr date 1 yo 31 tak column me to last month ka date current month ki date ke barabar apne aap le le dash board me mean lmtd vs mtd banane me dashboard me hm myd ka data ek spreadsheet me daale to jo dusari ek spreadsheet me pure mahine ka dump pada h usame se ke aaj tak ki date ka data apne aap utha le

[@nramesh3180]

hi sir please count ex ; (12346789) explain this formula number count (8)

[@JavedMohd-o1s]

🥰🥰🥰🥰🥰

[@NavratnaBupharia]

i want to meet you sir