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
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.
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
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
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.
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
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.
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🥺
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?
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
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.
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
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
provide those excel sheet so that people can practice at the same time ....
you making thing quite simple, thanks...
Profound way of teaching...great Sir
Sir COUNTIF se me jan feb march vala example try kar raha hu pn meta answer Zero hi show kar raha he
Same here
Countif me apples wala bhi kr rha hun to answer zero aa rha hai. Please help 🙏
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
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.
the equation formula on the right, how do you write it in excel? please, explain. thanks
Please sir, I don't get the formula
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
how did you got the formulas of permit and comb
=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
Your explanation is extremely superb. In a simple way you make learners understand.
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
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
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.
how we can contact you
Hi
I am getting a error for the following
=offset($A$2,,,counta(A:A)-1,1)
Please suggest
Thanks so so musch, your videos have help me alot to understand excel , can you please make a vedio of PAYE formula in excel
Thank you you are legend 🎉
Hi please make video on countifs
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
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.
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.
in this video the last two formulas not understanding, please clear my doubt. how can i do
How can we show formula only in specified cells but not in every cell
Thank you so much sir for all vedios this helps me understanding so easily i m learning english speaking also 😊
Brilliant work 👏🏽
How can we write permutation and combination formulas in excel or you copied it from somewhere else ?
PERMUT and COMBIN are the inbuilt functions in excel.
Insert equation
Thanks for this video it was very helpful learn so many things in excel thanks team for this wonderful effort
In count if why we right [apple] why we can never select it.
How to ONLY count positive OR negative numbers in selected sells?
greattt explanation,so much patience , very helpful video
Hello Sir, can you please provide the formula to find number of characters or digits are there in a particular cell.
Hi Sir,
In the function of consolidate, we can choose:'count', 'countnumber'. What is the difference?
Thank you.
HI sir
i want to know the number of apples every day - what is the formula ?
Thank u sir
Thank you ! Very much. It 's useful for me
THANK YOU SO MUCH REALLY SO MUCH HELPFUL WITH A SIMPLE TECHNIC.
Hi, what if any one of the word has space among rest of the same word. How to use trim and use countif
thank you sir 🙂🙂
VERY HELPFUL
THE TEACHER IS AWESOME
Sir yeh formula nhi lg rha mere excel me #value aarha hai repeat me
thank you sir for explaining in english
I need basic excel to advance excel fro youtube
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🥺
Well
Question: for countif, what if I want to know how many repetitions of *32* apples there are, not just apples?
HOW TO SUM , MULTI NAME WITH MULTI FIGURE ??
S A p chennai , Your Coaching is Excellent
I come to your videos you are awsm..but some times i feel like i cant concentrate more coz you are in hurry.
can we use COUNTIFS() function Using Today()
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?
I like your method of teaching. super
Thank you sir
Sir can you explain little bit hindi
You are great at explaining. Thanks so much!
THANK YOU SIMPLE TO THE POINT
quick,easy,not wasting time....u r toooooooooooooooo gud
Fluent way of answering..... ♥️🙏
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
Best teach
i love you
Where can I get this dataset?
Thank u
Thanks
Any app? Of tutorial point
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
thank you sir.....helped me alot
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.
Thank you brother, it was easy explaination
Excellent video bud helped me quote alot for my CAT exam
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
Please reply
Try using countif function
=COUNTIF(A3:F6,">10")
You will get the answer
@@nbandawane thanks dear i was searching for the same...
Thank you😊❤😊❤😊
Super sir. Tq so much
easily explained
Feels like back to school.
Very Clearly Explained..
Supper explanation
U r rocking Sir 🙏🙏
didn't understand
Thank You
Amazingly taught sir
Suoer sir
bro your explanation was awesome!
Nice & Crisp
Sir tell me countifs function
Good explanation
Thanks bro
didn't understand
Sir Your video is very simple to understand your voice is very clear
Thank you🌹🌹 keep it up.. 😘