TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS
1. How to use count function in excel
2. How to use counta function in excel
3. How to use countblank function in excel
4. How to use countif function in excel
5. How to use countifs function in excel
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Playlist Folder-Basic Excel-counttop5.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
##isnamatch#Innozant #misinterviewquestions
Sir you are the best! Everyone in TH-cam 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👏👏👏
Thanks Mounika for your valuable appreciation and Feedback.Finally main jis soch ke saath aaya tha TH-cam 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 TH-cam but you recognise,Really means a lot to me,God bless you dear.Have a wonderful career ahead ❤️
Very True
Great information !sir g .countifs and sumifs ki examples krwa dein. @@Innozant
मजा आ गया सर आपके वीडियो से बहुत 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 तो तुरंत लग जाता है इसका क्रेडिट केवल आपको ही जाता है क्युकी आप बहुत अच्छे से किसी भी टोपीक को समझाते हो 🙏🙏🙏🙏
Bht vidoes dkhy smjh ni a rhaa thaa... Best video.. concept clear ho gyaa Thank you so much..
❤️👍
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.
Thanks Bindu ,Really means a lot to me.Keep learning ❤️..Keep Exploring.
Have. A wonderful career ahead dear👍♥️
@@Innozant stay blessed and keep rising
Thanks for quick response. 🙏🙏
Well teaching. Standing my intlect
सर आप की और मेरी चोइस मिलती जुलती है जैसे आपको टी - शर्ट और ऐकसल पसंद हे वैसे मुजे भी Thanks for teach us
Thanks..😀
Thank you Sir aapne bahut acche se sikhaya mujhe acche se clear hua.
Thanks Daksh
Sir your way of delivering lecture is very awesome ❤. You are doing a very great job by helping a lot of people.❤
Thanks.Keep Learning
جزاکم اللّٰہ خیرا کثیرا کثیرا
Thanks for teaching different different types of formulas.
Thanks Hemant ji
Thank you.
Pls. Show the details example or another uses.
bhot acha concept tha concept dhanewaaad
Thanks dear..aapko mehnat krte dekh acha feel hota hai..iska revert jaroor milega aapko
@@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
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....
Really means a lot to me
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?
Thanks Brother, It is so helpful.
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.
Thanks Shrikant.Really means a lot to me..Hope you and your family are fine ,healthy and happy..God bless you mJeeo learning.❤️🙏
Aap bahut achha samjaye h
Sir aapka vidio dekh kr bahut kuchh sikha excel me bahut achha explain krte ho ..kya VBA ka series hai kya mujhe nhi mila..
Thanks..Abhi VBA series start nhi kiya hai jald krenge
Please sir mai wait kr rha hue!!
u r amazing sir bahut acche teacher hai aap
Thanks Ankita ,God bless You dear
sir data analytics ka video pura bnayiye sir, hum apka video ko details se sikh rha hu, very very thankful sir love you 😘
👍
Bahut achcha lga
Apke caunt,caunta,cauntblank,cauntifs
Our batana kuch excel me
Thanks..Aate rhenge videos dear❤️
This is called teaching with feelings .
Thanks Naresh Ji.. Really means a lot to me
So nice explanation for all levels 👏
Thanks dear
Thank you so much Sir
Very good method
I wanted to bring earthquake in my learning through ur teaching. Thanks Rajeev Jee..
Thanks dear..Keep exploring
Thanku sir another most most important explanation for count function. Good night sir
Thanks Satish ji.. Happy learning dear..Nice to see ,you learn everyday
Nice sir..
Which of them is least time consuming??
Smart boy love from Pakistan ♥️
Thanks Nasir sahab
Thankyou sir ❤
Thank you sir
Sir excel pe billing ka bi bta do ik br
sir countifs and sumifs me kitne bar criteria range and criteria select kr skte hai. koi limit hai ya unlimited times.
please reply sir
Sir please share or let us know from where we can collect raw data for using multiple formulas of advanced excel.
Example sheet is there..kindly download assigment master folder fekm video description
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?
Very nice video sir g.
Thanks Bhoopi..u r sincere candidate...good
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??
You are Great sir
❤💖💖🙏🙏
Ap n jese count,countA,count if sekhaya h isi tarha sum,sumif bhi pori vedio uplodd kr den?
Saare videos sequence wise upload hain basic excel playlist me
Thanks
Nice sir
Thanks u
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
Hi
Can u explain countifs function using two sheets
Hi Nidhi you may follow Excel Maharaj series after finishing basic excel playlist
Awesome sir 👌👌👌
Sir, how to donot count blank cell which contains spaces in cell , using counta
The bestest best❤
Count function ke upper aur averageifs ke down me jo functions h uske bare me bataye sir 🙏🙏
I was waiting for this video..thank u😊
Acha Ji,in this video I discussed concept only..Wait for more examples to come.
@@Innozant okk.. sir😊
Good morning. I have a question. How do I count different words from a single column in excel 365.
U r d best sir... But how to remember all the formulas sir ? Plz tell me some tricks
hahaha.. apnr aap practice ke saath yaad rhne lgega dear
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.
Normal Ms office ki knowledge..ms word aur excel both
@@Innozant thank you sir thank u very much sir
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
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
Sumif or sumifs ke bare me easy method se sikhiye
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?
Sir aap jo bhi sikhate hai uska excel sheet bhi video ke saath daale meri aap se request hai
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
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,
Practice file is there Playlist wise and Video example wise as well.You may find two seprate link in video description
@@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
Sir, some people says dat excel is dead.. Better learning R.. I don't know. Which is most useful for learning?
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.
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
Kindly watch this video your doubt may clear with this
th-cam.com/video/Z-ElRbzWL2I/w-d-xo.html
@@Innozant Thank you sir.. Ur information is motivate us..
Start your learning Now.Best of luck.
Nice sir
Sir You are Great Teacher. I learnt a lots yours all playlist video. Thank you for your gudidence sir ji.
Thanks Sandeep Ji..keep it up
Beautiful 👌🙏
Thanks Arti..Gn
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?
Question explain kijiye ya data share ..waise filtered databko sub krne ke kai approach..using aggregate or subtotal.
@@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?
AB0
CN5
AB1
NL0
NL0
NL1
SA3
count of records which
doesn’t contain 0
which formula is fit for this question?
Nice explain sir ❤
Thanks Ravi Ji..tc..HV a Great day
Badia sir
Thanks dear
Good sir
Sir how to count coloured cell in given range...
Sir, plz let us know how to count green colored cell in given range of colored cells...
Sir agar apni koi excel ki problem aapse share krni ho to kese kr skta hu
What is there are more than 2 criteria for countifs ?
.. i just know know till 2 conditions
No issue at all..kindly explain your query or connect us via telegram id @innozantofficial
I waiting for your upcoming excel video
New video tomorrow.
NICE VEDIO SIR
Thanks Sathya🙏❤️
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 👍
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
@@Innozant 🙏sir
Sir please help me kisi particular district k ander kitne team members working h kaise check karenge
Couunif with criteria use kriye Vermaji..
Maine padhaya hai na😊❤️👍
Sir .. Countifs me agar 3 to 4 criteria ho..Ek cell k under To kese kare ge..
Sir how can i remove space count in counta formula.
Use substitute instead
👌👌👌
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?
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.
@@Innozant sir i sent that query some days before
@@mehakmaini9243 Whatsapp or mail?
@@Innozant sir WhatsApp
Sir mi beginner hun playlist mein Kai tarah ki video hai video kahan se mi start karu
Basic excel-The learning begins playlist se start kariye learning journey apni
If I am having multiple data month wise and need month wise unique count, how do we get?
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
sir you wow
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
How i can download the file for practise for each video
Download assignment master folder from videos description
اسلام علیکم سر جی کیا حال چال ہے ٹھیک ٹھاک ہو سر میراایک سوال ہے کہ اگر میں ایک کالم میں 1 لکھوں تو دوسرے کالم میں اشاریہ پچاسں لکھا جائے تو ایسا کوئی فارمولا مجھے بتائیں ۔
Bhut badiya sir, but m practical b krti hu apki vedio k sath, but boolakad hu baar baar bhool jati hu.
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
I have knowledge all formula but i want different different types uses of every formula
Have patience..Thak jaoge aap lekin conceptual video aate rhenge humesha..so be ready 😊👍
Waiting for your more videos as you said in this one. Every video is precious and unique.
Soon dear..may b today evening 😊
❤️❤️❤️❤️
Sir hame excel ke sare short cut chahiye
Seprate chaiye apko .wo upload kr denge
Mere pass bahot data usko bhai ek excell sheet me Dashbord bana na hai ...Daily data pase karne par Dashbord auto update ho
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.
Good morning sir
How to count duplicate
Number of ways to count duplicate value in excel,You may find our video for the same in YT channel
I am from Gujarat city Bhavnagar
hi sir
please count ex ; (12346789) explain this formula number count (8)
Im not coward sir i am ready 👍
This is what I expect
🎉
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
Sir laptop par kaise freez hota hai please help..
Good Morning Sapna.
Function key(Fn) ke saath F4 press karna laptop me
@@Innozant ok sir thank you
Builder mahesh ramesh aise kitane naam hai woh kaise count kare?
Dipak R. Rathod . Good. 59 years old
cohort_name venture_code
D2C_IGN_3.1_ADANI VEN-BUSI-3957
D2F_IGN_3.1_SVIM_2nd Year VEN-ADPI-5147
D2F_IGN_3.1_SVIM_1st Year VEN-SCOU-2061
D2F_IGN_3.1_AMU VEN-NATI-1460
Sir, This is the data I have in which i want this venture code Count as per COHORT NAME.. Meaning:- Ek batch mein kitne ventures form hue? so which count IF formula we will use sir? please help
Your code is 5147,3957??
Cohort name is D2C_IGN_3.1_ADANI
VENTURE CODE IS :- VEN-BUSI-3957
Respectively cohort name then venture code
Alfa numeric it is
🥰🥰🥰🥰🥰