MS Excel - Count Functions

  Рет қаралды 528,079

TutorialsPoint

TutorialsPoint

Күн бұрын

Пікірлер: 109
@TutorialsPoint_
@TutorialsPoint_ Жыл бұрын
To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.
@jeebitgomango3435
@jeebitgomango3435 5 ай бұрын
Profound way of teaching...great Sir
@sarikardass6052
@sarikardass6052 2 жыл бұрын
Your explanation is extremely superb. In a simple way you make learners understand.
@sahishaa
@sahishaa 2 жыл бұрын
quick,easy,not wasting time....u r toooooooooooooooo gud
@EddisP.Martol
@EddisP.Martol 2 ай бұрын
Thanks so much for the tutorial and am always learning from your videos
@GoshidhaaM.S
@GoshidhaaM.S Жыл бұрын
greattt explanation,so much patience , very helpful video
@risingstarofup8518
@risingstarofup8518 Жыл бұрын
Fluent way of answering..... ♥️🙏
@angelsteffy9679
@angelsteffy9679 2 жыл бұрын
Thanks for this video it was very helpful learn so many things in excel thanks team for this wonderful effort
@ashwinkshukla2595
@ashwinkshukla2595 9 ай бұрын
Brilliant work 👏🏽
@divyasoniarts52
@divyasoniarts52 4 жыл бұрын
Thank you so much sir for all vedios this helps me understanding so easily i m learning english speaking also 😊
@oumermuhammed4666
@oumermuhammed4666 10 ай бұрын
Thank you you are legend 🎉
@tiaanlorenzen7778
@tiaanlorenzen7778 5 жыл бұрын
Excellent video bud helped me quote alot for my CAT exam
@pipalmohit
@pipalmohit 6 жыл бұрын
provide those excel sheet so that people can practice at the same time .... you making thing quite simple, thanks...
@reenageo5528
@reenageo5528 4 жыл бұрын
VERY HELPFUL THE TEACHER IS AWESOME
@varinderkaur3282
@varinderkaur3282 3 жыл бұрын
U r rocking Sir 🙏🙏
@Faster_onlineinfo
@Faster_onlineinfo 3 жыл бұрын
Sir Your video is very simple to understand your voice is very clear Thank you🌹🌹 keep it up.. 😘
@azhagappapillaisubramaniya9305
@azhagappapillaisubramaniya9305 3 жыл бұрын
S A p chennai , Your Coaching is Excellent
@mohammedkashif1869
@mohammedkashif1869 2 жыл бұрын
Very Clearly Explained..
@palanisamyr3212
@palanisamyr3212 4 жыл бұрын
I like your method of teaching. super
@imFadingAurora
@imFadingAurora 5 жыл бұрын
You are great at explaining. Thanks so much!
@Thisara-of5sz
@Thisara-of5sz 3 жыл бұрын
Thank you ! Very much. It 's useful for me
@rupammalakar4035
@rupammalakar4035 4 жыл бұрын
Feels like back to school.
@adminiha9453
@adminiha9453 4 жыл бұрын
THANK YOU SO MUCH REALLY SO MUCH HELPFUL WITH A SIMPLE TECHNIC.
@sumanguduru2234
@sumanguduru2234 5 жыл бұрын
Hi Bhai.The way u explain things is amazing in any concept. I always refer your video relating to excel and word tips when ever i get doubt. thanks
@tamilsiva1947
@tamilsiva1947 6 жыл бұрын
bro your explanation was awesome!
@ndelpurg
@ndelpurg 5 жыл бұрын
THANK YOU SIMPLE TO THE POINT
@mty50m1
@mty50m1 4 жыл бұрын
Thank you brother, it was easy explaination
@sanjayjadhav3072
@sanjayjadhav3072 4 жыл бұрын
thank you sir.....helped me alot
@nikhilgs7942
@nikhilgs7942 Жыл бұрын
thank you sir for explaining in english
@bengalisofpatna-bihar4728
@bengalisofpatna-bihar4728 4 жыл бұрын
Amazingly taught sir
@edwardthoronka7344
@edwardthoronka7344 2 жыл бұрын
Thanks so so musch, your videos have help me alot to understand excel , can you please make a vedio of PAYE formula in excel
@amanbhargavaofficial
@amanbhargavaofficial 3 жыл бұрын
Thank you😊❤😊❤😊
@adnanhaider1340
@adnanhaider1340 5 ай бұрын
Best teach
@komalkumawat3865
@komalkumawat3865 11 ай бұрын
thank you sir 🙂🙂
@k.kittisagar3046
@k.kittisagar3046 4 жыл бұрын
Supper explanation
@prudvikrishna7342
@prudvikrishna7342 4 жыл бұрын
Super sir. Tq so much
@simrandiwan6340
@simrandiwan6340 8 ай бұрын
hello sir, i have a question, whenever i write after the select range like you wrote Apple you have got the answer but i get always 0. why? i can not write in any formula i have to select the cell
@EyiBillion
@EyiBillion 2 жыл бұрын
Thanks for making Excel cheap. I am working on a project and got stucked . Need a one on one tutelage. I am ready to commit myself financially. How do i get starting with you? Would be glad to read from you. Respectfully.
@brahmaiaheesam6696
@brahmaiaheesam6696 5 жыл бұрын
Good explanation
@prathmeshsawantihy4650
@prathmeshsawantihy4650 2 жыл бұрын
easily explained
@yashiagrawal5212
@yashiagrawal5212 2 жыл бұрын
how did you got the formulas of permit and comb
@kellyoku
@kellyoku 4 жыл бұрын
the equation formula on the right, how do you write it in excel? please, explain. thanks
@kapilmalu1475
@kapilmalu1475 4 жыл бұрын
Nice & Crisp
@MrKanojia
@MrKanojia 2 жыл бұрын
Sir, can you help me with one query? I have once date (08th Aug'22) and I need to know what will be the future date after specific number of days (7 days) also taking weekends into consideration.
@gangadharsaraswati516
@gangadharsaraswati516 3 жыл бұрын
Thank u sir
@saubhagyaswain9944
@saubhagyaswain9944 6 жыл бұрын
Doubt- Oce we use "countblank" function on a large dataset and found that there are suppose 3 cells which are empty. How can I go directly to those cells which it has counted just to verify that I have left them blank knowingly or some data got deleted by mistake? It'll be very useful if you can answer this doubt.
@NitroBlaze2023
@NitroBlaze2023 6 жыл бұрын
Using Go to special feature you can directly jump to blank cells. Press F5 key to open Go to dialog box and select Go to Special.
@rishiakkewar7501
@rishiakkewar7501 2 жыл бұрын
in this video the last two formulas not understanding, please clear my doubt. how can i do
@deepakrajendran9048
@deepakrajendran9048 3 жыл бұрын
Hi, what if any one of the word has space among rest of the same word. How to use trim and use countif
@santhu4545
@santhu4545 6 жыл бұрын
How can we write permutation and combination formulas in excel or you copied it from somewhere else ?
@NitroBlaze2023
@NitroBlaze2023 6 жыл бұрын
PERMUT and COMBIN are the inbuilt functions in excel.
@somenmaji7078
@somenmaji7078 6 жыл бұрын
Insert equation
@KwokVivi
@KwokVivi 4 жыл бұрын
Hi Sir, In the function of consolidate, we can choose:'count', 'countnumber'. What is the difference? Thank you.
@srikanthgubba9677
@srikanthgubba9677 4 жыл бұрын
Any app? Of tutorial point
@Miss_smiling_brunette
@Miss_smiling_brunette 3 жыл бұрын
Turned out very helpful for me but I've one query suppose i wanna count the values lying in a data array, in a specific given range how do i do that? Please reply and guide if possible for you🥺
@yeriks.s9240
@yeriks.s9240 3 жыл бұрын
HELLO SIR ,THANK YOU FOR MAKING EXCEL FUN !!! MAY I REQUEST YOU DO VIDEO ON HOW TO SUM UP DATA FROM MULTIPLE WORKSHEETS using Sumproduct, sumif and indirect formulars thank you
@mywaydacs9440
@mywaydacs9440 3 жыл бұрын
HI sir i want to know the number of apples every day - what is the formula ?
@jayeshsaroj3944
@jayeshsaroj3944 5 жыл бұрын
I come to your videos you are awsm..but some times i feel like i cant concentrate more coz you are in hurry.
@santhu4545
@santhu4545 6 жыл бұрын
How can we show formula only in specified cells but not in every cell
@jer-man
@jer-man 3 жыл бұрын
Question: for countif, what if I want to know how many repetitions of *32* apples there are, not just apples?
@ShivaKumar-gc6so
@ShivaKumar-gc6so 2 жыл бұрын
Hello Sir, can you please provide the formula to find number of characters or digits are there in a particular cell.
@futurecabrijesh2103
@futurecabrijesh2103 3 жыл бұрын
Sir COUNTIF se me jan feb march vala example try kar raha hu pn meta answer Zero hi show kar raha he
@pritamkapoor1571
@pritamkapoor1571 3 жыл бұрын
Same here
@pritamkapoor1571
@pritamkapoor1571 3 жыл бұрын
Countif me apples wala bhi kr rha hun to answer zero aa rha hai. Please help 🙏
@shamsurehmanjalalzai
@shamsurehmanjalalzai 5 жыл бұрын
Thank you very much sir But how can i manege name of students by ( a. B. C ) in thier names if you have tim plz show me this
@mrcdesh
@mrcdesh 5 жыл бұрын
Thank You
@bbalajinaik4501
@bbalajinaik4501 2 жыл бұрын
Where can I get this dataset?
@anandbharadwaj705
@anandbharadwaj705 2 жыл бұрын
Thanks
@2011Savere
@2011Savere 6 жыл бұрын
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?
@something_new280
@something_new280 4 жыл бұрын
Hi bro I have data date wise sales and purchase I need you are support in excel when IAM enter specific any date I need that date how many sales and purchase happen I require counts like I use today date I required 100 sales and purchase 50 like Wich formula I need to use
@hemantshedage7974
@hemantshedage7974 2 жыл бұрын
Thank u
@ramnathdikshit4917
@ramnathdikshit4917 3 жыл бұрын
Hi I am getting a error for the following =offset($A$2,,,counta(A:A)-1,1) Please suggest
@phallinsoeun3777
@phallinsoeun3777 4 жыл бұрын
Hello sir now i have one Q for you help: i have date in excel is 1- A,B,A,C,G 2- A,B,A,C,G 3- A,A,C,G 4- A,B,C,G i want count 1to4 have A how much ? please help me too
@NaumanSiddiqee
@NaumanSiddiqee 5 жыл бұрын
Hello Sir! How can I count No. of Present Mark in a week (From Monday to Saturday) on weekly basis for the whole month using formula and not using VBA.
@emanbhatti2085
@emanbhatti2085 4 жыл бұрын
In count if why we right [apple] why we can never select it.
@ashishgoel1852
@ashishgoel1852 2 жыл бұрын
Hi please make video on countifs
@digitalaayam2503
@digitalaayam2503 5 жыл бұрын
Thanks bro
@ramonmn5899
@ramonmn5899 4 жыл бұрын
How to ONLY count positive OR negative numbers in selected sells?
@abhishekkumar-kh8ln
@abhishekkumar-kh8ln 5 жыл бұрын
Sir I like your video too much . Sir I have one problem. I have 5 value like, 15,20, 8,9,5. In this I want to count value which less than 10 and greater than 15 . How count formula is apply
@abhishekkumar-kh8ln
@abhishekkumar-kh8ln 5 жыл бұрын
Please reply
@TalesandTales
@TalesandTales 5 жыл бұрын
Try using countif function
@nbandawane
@nbandawane 5 жыл бұрын
=COUNTIF(A3:F6,">10") You will get the answer
@perumalprasath6012
@perumalprasath6012 4 жыл бұрын
Suoer sir
@LearnBulk
@LearnBulk 3 жыл бұрын
Well
@misbackendfinbud6853
@misbackendfinbud6853 5 жыл бұрын
can we use COUNTIFS() function Using Today()
@fyneosunju5870
@fyneosunju5870 4 ай бұрын
Please sir, I don't get the formula
@srikanthgubba9677
@srikanthgubba9677 4 жыл бұрын
I need basic excel to advance excel fro youtube
@priyanshidangi3452
@priyanshidangi3452 4 жыл бұрын
Sir yeh formula nhi lg rha mere excel me #value aarha hai repeat me
@tomcat1583
@tomcat1583 4 жыл бұрын
Can someone solve this please? If I Enter 500 How to enter formula to display. 30. 70. 100. 100 100 row wise using IF Formula 1-30 ---. 30 31-100 --- 70 101-200--- 100 201-300--- 100 301-400--- 100 Above 400
@dharmendergiri5538
@dharmendergiri5538 4 жыл бұрын
HOW TO SUM , MULTI NAME WITH MULTI FIGURE ??
@Farhan-m4p
@Farhan-m4p Жыл бұрын
=50+70+80+90+40+30+60+40+30+20Now what do you think about the numbers here?Now how to count the numbers here
@saikrish6520
@saikrish6520 5 жыл бұрын
Sir tell me countifs function
@ishanmistri7720
@ishanmistri7720 Жыл бұрын
i love you
@khanosama756
@khanosama756 3 жыл бұрын
Sir can you explain little bit hindi
@VarshaHiremath-z5i
@VarshaHiremath-z5i 16 күн бұрын
😂😂😂😂😢😢😢😅😅😅😅😅😅🎉😅😢
@vivekshetty4980
@vivekshetty4980 2 күн бұрын
kzbin.info/www/bejne/aGK3Z5-Xrad_bpIsi=LRGaSH-2XeAffVRf
@dikidomalepcha2946
@dikidomalepcha2946 4 жыл бұрын
didn't understand
@pkrt-2922
@pkrt-2922 2 жыл бұрын
how we can contact you
@Cafe_Sona...
@Cafe_Sona... Жыл бұрын
Thank you sir
@dikidomalepcha2946
@dikidomalepcha2946 4 жыл бұрын
didn't understand
MS Excel - Statistical Functions
9:34
TutorialsPoint
Рет қаралды 506 М.
How to use COUNTIF and COUNTIFS in Microsoft Excel
14:36
Kevin Stratvert
Рет қаралды 911 М.
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
It works #beatbox #tiktok
00:34
BeatboxJCOP
Рет қаралды 41 МЛН
MS Excel - Text Functions
9:49
TutorialsPoint
Рет қаралды 1,2 МЛН
MS Excel - Vlookup in Excel Video Tutorials
6:38
TutorialsPoint
Рет қаралды 10 МЛН
MS Excel - IF Function
7:15
TutorialsPoint
Рет қаралды 1,4 МЛН
MS Excel - Pivot Table Example 1 Video Tutorials
15:05
TutorialsPoint
Рет қаралды 6 МЛН
MS Excel - Conditional Formatting Part 1
10:42
TutorialsPoint
Рет қаралды 1,3 МЛН
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 595 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН