Тёмный

MS Excel - Count Functions 

Tutorialspoint
Подписаться 3,5 млн
Просмотров 500 тыс.
50% 1

MS Excel - Count Functions
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

Опубликовано:

 

14 янв 2018

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 104   
@TutorialsPoint_
@TutorialsPoint_ Год назад
To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "RU-vid12" to get ‘’FLAT 12%’’ OFF at Checkout.
@sarikardass6052
@sarikardass6052 2 года назад
Your explanation is extremely superb. In a simple way you make learners understand.
@imFadingAurora
@imFadingAurora 4 года назад
You are great at explaining. Thanks so much!
@sumanguduru2234
@sumanguduru2234 4 года назад
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
@angelsteffy9679
@angelsteffy9679 Год назад
Thanks for this video it was very helpful learn so many things in excel thanks team for this wonderful effort
@sahishaa
@sahishaa Год назад
quick,easy,not wasting time....u r toooooooooooooooo gud
@adminiha9453
@adminiha9453 4 года назад
THANK YOU SO MUCH REALLY SO MUCH HELPFUL WITH A SIMPLE TECHNIC.
@ndelpurg
@ndelpurg 5 лет назад
THANK YOU SIMPLE TO THE POINT
@divyasoniarts52
@divyasoniarts52 3 года назад
Thank you so much sir for all vedios this helps me understanding so easily i m learning english speaking also 😊
@user-gk3wo1bm5h
@user-gk3wo1bm5h 11 месяцев назад
greattt explanation,so much patience , very helpful video
@tiaanlorenzen7778
@tiaanlorenzen7778 4 года назад
Excellent video bud helped me quote alot for my CAT exam
@tamilsiva1947
@tamilsiva1947 5 лет назад
bro your explanation was awesome!
@Faster_onlineinfo
@Faster_onlineinfo 2 года назад
Sir Your video is very simple to understand your voice is very clear Thank you🌹🌹 keep it up.. 😘
@reenageo5528
@reenageo5528 4 года назад
VERY HELPFUL THE TEACHER IS AWESOME
@ajitmohanty1114
@ajitmohanty1114 3 года назад
Thanks sir you will be remembered.....
@mty50m1
@mty50m1 4 года назад
Thank you brother, it was easy explaination
@risingstarofup8518
@risingstarofup8518 Год назад
Fluent way of answering..... ♥️🙏
@KwokVivi
@KwokVivi 4 года назад
Hi Sir, In the function of consolidate, we can choose:'count', 'countnumber'. What is the difference? Thank you.
@palanisamyr3212
@palanisamyr3212 4 года назад
I like your method of teaching. super
@Thisara-of5sz
@Thisara-of5sz 2 года назад
Thank you ! Very much. It 's useful for me
@mohammedkashif1869
@mohammedkashif1869 Год назад
Very Clearly Explained..
@ashwinkshukla2595
@ashwinkshukla2595 2 месяца назад
Brilliant work 👏🏽
@pipalmohit
@pipalmohit 5 лет назад
provide those excel sheet so that people can practice at the same time .... you making thing quite simple, thanks...
@bengalisofpatna-bihar4728
@bengalisofpatna-bihar4728 3 года назад
Amazingly taught sir
@sanjayjadhav3072
@sanjayjadhav3072 3 года назад
thank you sir.....helped me alot
@Nomicfa
@Nomicfa 4 года назад
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.
@varinderkaur3282
@varinderkaur3282 2 года назад
U r rocking Sir 🙏🙏
@yeriks.s9240
@yeriks.s9240 2 года назад
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
@oumermuhammed4666
@oumermuhammed4666 4 месяца назад
Thank you you are legend 🎉
@azhagappapillaisubramaniya9305
@azhagappapillaisubramaniya9305 3 года назад
S A p chennai , Your Coaching is Excellent
@kellyoku
@kellyoku 4 года назад
the equation formula on the right, how do you write it in excel? please, explain. thanks
@smiling_crumbles6409
@smiling_crumbles6409 2 года назад
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🥺
@rupammalakar4035
@rupammalakar4035 3 года назад
Feels like back to school.
@MrKanojia
@MrKanojia Год назад
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.
@prudvikrishna7342
@prudvikrishna7342 3 года назад
Super sir. Tq so much
@santhu4545
@santhu4545 5 лет назад
How can we show formula only in specified cells but not in every cell
@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
@2011Savere
@2011Savere 5 лет назад
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?
@brahmaiaheesam6696
@brahmaiaheesam6696 4 года назад
Good explanation
@jer-man823
@jer-man823 2 года назад
Question: for countif, what if I want to know how many repetitions of *32* apples there are, not just apples?
@simrandiwan6340
@simrandiwan6340 Месяц назад
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
@nikhilgs7942
@nikhilgs7942 Год назад
thank you sir for explaining in english
@yashiagrawal5212
@yashiagrawal5212 Год назад
how did you got the formulas of permit and comb
@k.kittisagar3046
@k.kittisagar3046 3 года назад
Supper explanation
@edwardthoronka7344
@edwardthoronka7344 Год назад
Thanks so so musch, your videos have help me alot to understand excel , can you please make a vedio of PAYE formula in excel
@shamsurehmanjalalzai
@shamsurehmanjalalzai 4 года назад
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
@komalkumawat3865
@komalkumawat3865 4 месяца назад
thank you sir 🙂🙂
@ShivaKumar-gc6so
@ShivaKumar-gc6so Год назад
Hello Sir, can you please provide the formula to find number of characters or digits are there in a particular cell.
@srikanthgubba9677
@srikanthgubba9677 3 года назад
Any app? Of tutorial point
@kapilmalu1475
@kapilmalu1475 4 года назад
Nice & Crisp
@mywaydacs9440
@mywaydacs9440 2 года назад
HI sir i want to know the number of apples every day - what is the formula ?
@eyitayoeyitayo-lawal2331
@eyitayoeyitayo-lawal2331 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.
@mrcdesh
@mrcdesh 4 года назад
Thank You
@saubhagyaswain9944
@saubhagyaswain9944 5 лет назад
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 5 лет назад
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.
@Cafe_Sona...
@Cafe_Sona... Год назад
Thank you sir
@bbalajinaik4501
@bbalajinaik4501 Год назад
Where can I get this dataset?
@misbackendfinbud6853
@misbackendfinbud6853 4 года назад
can we use COUNTIFS() function Using Today()
@juganyajj0159
@juganyajj0159 3 года назад
Thank you so much
@digitalaayam2503
@digitalaayam2503 5 лет назад
Thanks bro
@ramnathdikshit4917
@ramnathdikshit4917 2 года назад
Hi I am getting a error for the following =offset($A$2,,,counta(A:A)-1,1) Please suggest
@amanbhargava2702
@amanbhargava2702 3 года назад
Thank you😊❤😊❤😊
@prathmeshsawantihy4650
@prathmeshsawantihy4650 2 года назад
easily explained
@rishiakkewar7501
@rishiakkewar7501 Год назад
in this video the last two formulas not understanding, please clear my doubt. how can i do
@gangadharsaraswati516
@gangadharsaraswati516 2 года назад
Thank u sir
@hemantshedage7974
@hemantshedage7974 2 года назад
Thank u
@ramonmn5899
@ramonmn5899 4 года назад
How to ONLY count positive OR negative numbers in selected sells?
@something_new280
@something_new280 3 года назад
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
@anandbharadwaj705
@anandbharadwaj705 2 года назад
Thanks
@santhu4545
@santhu4545 5 лет назад
How can we write permutation and combination formulas in excel or you copied it from somewhere else ?
@NitroBlaze2023
@NitroBlaze2023 5 лет назад
PERMUT and COMBIN are the inbuilt functions in excel.
@somenmaji7078
@somenmaji7078 5 лет назад
Insert equation
@perumalprasath6012
@perumalprasath6012 3 года назад
Suoer sir
@saikrish6520
@saikrish6520 5 лет назад
Sir tell me countifs function
@phallinsoeun3777
@phallinsoeun3777 3 года назад
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
@jayeshsaroj3944
@jayeshsaroj3944 4 года назад
I come to your videos you are awsm..but some times i feel like i cant concentrate more coz you are in hurry.
@priyanshidangi3452
@priyanshidangi3452 4 года назад
Sir yeh formula nhi lg rha mere excel me #value aarha hai repeat me
@LearnBulk
@LearnBulk 3 года назад
Well
@emanbhatti2085
@emanbhatti2085 3 года назад
In count if why we right [apple] why we can never select it.
@ashishgoel1852
@ashishgoel1852 Год назад
Hi please make video on countifs
@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
@salil10287
@salil10287 4 года назад
@@nbandawane thanks dear i was searching for the same...
@dharmendergiri5538
@dharmendergiri5538 3 года назад
HOW TO SUM , MULTI NAME WITH MULTI FIGURE ??
@srikanthgubba9677
@srikanthgubba9677 3 года назад
I need basic excel to advance excel fro youtube
@futurecabrijesh2103
@futurecabrijesh2103 2 года назад
Sir COUNTIF se me jan feb march vala example try kar raha hu pn meta answer Zero hi show kar raha he
@pritamkapoor1571
@pritamkapoor1571 2 года назад
Same here
@pritamkapoor1571
@pritamkapoor1571 2 года назад
Countif me apples wala bhi kr rha hun to answer zero aa rha hai. Please help 🙏
@ishanmistri7720
@ishanmistri7720 Год назад
i love you
@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
@user-gy1in3dk8z
@user-gy1in3dk8z 6 месяцев назад
=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
@khanosama756
@khanosama756 3 года назад
Sir can you explain little bit hindi
@dikidomalepcha2946
@dikidomalepcha2946 4 года назад
didn't understand
@praveenkumarramuturai1806
@praveenkumarramuturai1806 Год назад
how we can contact you
@dikidomalepcha2946
@dikidomalepcha2946 4 года назад
didn't understand
Далее
MS Excel - Statistical Functions
9:34
Просмотров 483 тыс.
MS Excel - Shortcuts Ctrl+A to Ctrl+Z
12:17
Просмотров 984 тыс.
[RU] Winline EPIC Standoff 2 Major | Group Stage - Day 1
8:42:47
Цены на iPhone и Жигули в ЕГИПТЕ!
50:12
The Excel COUNTIF and COUNTIFS Functions
4:53
Просмотров 90 тыс.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
MS Excel - Data Sorting
9:05
Просмотров 886 тыс.
MS Excel - IF Function
7:15
Просмотров 1,4 млн
MS Excel - Text Functions
9:49
Просмотров 1,2 млн
MS Excel - Basic Formulas
6:28
Просмотров 779 тыс.
MS Excel - Pivot Table Slice
9:38
Просмотров 397 тыс.
[RU] Winline EPIC Standoff 2 Major | Group Stage - Day 1
8:42:47