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