No comment, jis dedication & honesty ke sath app jo karte ho sir, wahi imandari agar har ek ka kaam main aa jaye toh yeh Desh sone ka ho jayega. Chahe politician, Doctor.... God Bless You.
No Words..M speechless..Sayad ye word mere liye really bht eham hai yadi aplogon ke life me main value add kar pa rha hu to ye sbse bada asset mere liye yhi hai Salil..God bless you .Nvr stop learning..Will alwaysa kee you maktivated with dose of success.👍👍❤️👍🙏
I have 5 years of exp in SAP and I hardly use Excel while working ...Now I m with perticular client who first completly works on excel and then share those requirements with us in excel ..I just started to understand or say learn excel and at the very first site I got this channel which is completly helpful...looking forward for more conceptual videos and also if you can teach us advanced functions in excel then I am happy to join !!
Wow...Great work...I am very happy to subscribe your channel and 100% satisfy with your teaching skill. Always I want to learn excel in depth and i have visited many you tube channels but never got satisfied. But now I got the right channel , finally....thanks and keep it up.
Thanks Mahima.. Really means a lot to me.❤️🙏 Recommend you to start your learning journey step by step in sequence playlist (Kindly watch Video description for videos in sequence playlist) and Assignment Master Folder are there for yout regular practice. We wlcome you to experience the taste of success with Innozant -Seed of success.Happy Learning ❤️🙏
You are Right Ghulam,There is no need to pay fees in institute ,Step by step in sequence complete course is there,Kindly learn (videos in sequence Playlist is available in video description) enhance your skills and succed.Happy learning
Explanation is very clear sir, with your lecture not only learning the function, also learning how to think logically it is very clear thanks for your lecture.
Thanks Vandana.Really means a lot to me.Recommend you to start your learning journey from playlist Basic Excel onwards (Videos in sequence playlist link given in Latest videos description) Thanks for being part of Innozant family.Happy Learning❤🙏
@@Innozant Sir.. I m watching all ur videos and learning best tricks from you... Thanks for recommendation.. Keep sharing this unbeatable knowledge with us... Thanks to you and your channel...🙏
Amazing tricks sir . 👏 . We enjoyed your video on you tube. Our knowledge is enhance day by day by following your channel . Stay healthy and stay blessed. 🙏
Sir ji aap ka har video pasand hai aur like tho zaroor bantha hai in advance .. last wala example thoda hard hai .. Sir ji aur bhi kuch easy example bathai ye na please.. logic clear nahi ho paya.. thank you .
Hi I am learning excel from 3 months by myself and the channel which I was watching earlier was chandoo ( if you know who is he then yes ) now I realised I should have watch ur videos first now coming to query Why didn't we direvtly writer "
Sorry now I realised that we have to copy paste the formula below and other months would not have same number of days or I can say other months would not have 30th as last day
Sir ek question h apne creteria 1 me jo greater than equal to 1 aprl 2019 liya h to vo date fr jitna b greater hoga 1 aprl 2019 se sara record check krega or same as 2nd creteria please btaiyega
@@Innozant Sir now a days everyone are teaching everything, but very few know the subject, and you mastered in excel. People need teachers like you. Thank you for educating people like me.
Thank you for uploading useful videos, regarding this particular tutorial, I stuck where the amount column imported as text instead of a number so applying the function not giving any output, so if you can suggest a way to fix the issue. Thank you again.
I have multiple condition for sumifs e.g values (+invoice -Crecit note-payment-adjustment), I want to formulation in single way without cell selection. pls advice.
I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?
Sir ji what is the easy way to learn excel conceptual .. should i learn any basic programming? I have been using sap all the time where i dont use much excel . Recently realised that I have to learn excel for my accounting work where i can easily use most of the easy functions however i am not able to think conceptually the way you have showed in the last example, it seems easy when i see your video however i doubt whether i can think the way you think . How to build the concept in Excel..
sir i have question that is why i use > or < or = into the inverted commas in sumif and sumifs function bt the another thing is in sumproduct function do not use > < or = into the inverted commas.what is the reason behind it.which function i use inverted commas where not.plz explain sir.
Chandan Sahab jab Kisi condition ke Saath Kuch aur associate karna HOTA hai Jaise ki ">"&A1 (date between) Ka sum chaiye man lo to sumif me Aise use krte h..jabki sumproduct me to direct range= conditiin lagate Hain to whana concatenate krne ke jagah (A1:A10=condition). Aise pass kr dete h yahan jarurat nhi hai. Telegram I'd join kariye koi query ho to..will discuss.. Telegram @innozantofficial
Hahaha..dear wo sab seprate hi the pehle,but folder delete ho jane ki wajahse dubara link playlist wise dena hua..kyunki 700+ videos hain itna possible nhi hai seprate link banana
Sir i tried this sumifs on the data which is having the heading of rows and coloumns , but i didn't Product Dept April may june cycle student 20 12 13 book class 30 41 34 pen class 33 23 34 book student 42 24 15 pen student 21 44 13 April Student Class Cycle Book Pen
Nice Sir, Sir i want you solve my query is, Sales person same but route is more of 2 in vertical, but date is horizontal with datewise sales amount & products in different array. how i find different date wise sum of sales person amount? please make a video these type question . i wait .......
Excel me mene aaj tak aisa koi nahi dekha ki jo aisa soch k (ek dum hatke) hame sikha raha ho.👏🙏😇
Thanks Brijesh Ji..Keep Learning ❤️
No comment, jis dedication & honesty ke sath app jo karte ho sir, wahi imandari agar har ek ka kaam main aa jaye toh yeh Desh sone ka ho jayega. Chahe politician, Doctor.... God Bless You.
No Words..M speechless..Sayad ye word mere liye really bht eham hai yadi aplogon ke life me main value add kar pa rha hu to ye sbse bada asset mere liye yhi hai Salil..God bless you .Nvr stop learning..Will alwaysa kee you maktivated with dose of success.👍👍❤️👍🙏
i am speechless sir...word nahi mil rahe hai kese tareef karu apki...You are best and top no 1.teacher in the world. of Excel
Thanks Deepak.God bless You dear.Happy Learning..❤️
Your explanation easily understand, your teaching style is great.
Because of your tutorials, I quit the habit of helper columns and try to solve the problem in single formula. Thanks 🙏
Namakar Sirjee, Bahot Badhiya aur Saral tarike se aapka explanation..... Dhanyawad.....
Thanks Vivek ji
Zabardast sir ji,
you're one of the reason for my excel skills upgrade.
Shaherana andaz mei sikhate ho love ur explanation
Thanks..Keep learning
Great tutorial. Love from Bangladesh❤❤
I have 5 years of exp in SAP and I hardly use Excel while working ...Now I m with perticular client who first completly works on excel and then share those requirements with us in excel ..I just started to understand or say learn excel and at the very first site I got this channel which is completly helpful...looking forward for more conceptual videos and also if you can teach us advanced functions in excel then I am happy to join !!
Dear Avinash..Kindly note that complete vidoe tutorial are available in our UA-cam channel from basic to advanced ❤️👍
Gajjjjjjjjjjjjab ka dimakh hai sir salute to level of thinking
Thanks Ganesh ji
Your way of teaching is simply great.....
Thanks Rupinder ji
Wah sir amazing solution diya apny. You are genius sir g. Live long life sir
Wow...Great work...I am very happy to subscribe your channel and 100% satisfy with your teaching skill. Always I want to learn excel in depth and i have visited many you tube channels but never got satisfied. But now I got the right channel , finally....thanks and keep it up.
Thanks Mahima.. Really means a lot to me.❤️🙏 Recommend you to start your learning journey step by step in sequence playlist (Kindly watch Video description for videos in sequence playlist) and Assignment Master Folder are there for yout regular practice.
We wlcome you to experience the taste of success with Innozant -Seed of success.Happy Learning ❤️🙏
GURU JI PRANAM .. tusi great ho sade india di hope ho
Thanks
Sir I am from Pakistan, great works. Ab mujhe kisi institute ja k Excel seakhne ki zarorat nahi... Aap ne hamari mushkil hal kardi.
You are Right Ghulam,There is no need to pay fees in institute ,Step by step in sequence complete course is there,Kindly learn (videos in sequence Playlist is available in video description) enhance your skills and succed.Happy learning
Sir you are megical totur I have ever seen In my life how effortlessly you understand concept of complexity content of excel which is unbelievable 🙏
Thanks Pawan..Good Night.. Happy Learning ♥️
Ultimate explanation, very nice!!
I don't have words to praise .AWESOME
Thanks Jaishri for wonderful feedback always from you.
Thank you sir very helpful video🥰
Bahut shandaar Sir.
Thanks dear
This video was professional level thankyou so much sir
Thanks Vikas
SIRJI , REALLY YOUR TECHNIC STYLE AMAZING , I NEVER GO FOR ANY COMPUTER CLASS BUT BY YOU I LEARN TOO MUCH..THANK YOU👍👍👍
Thanks Swapnil..God bless You dear
very useful sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks❤🙏
कया बात है साहेब प्रशंसनीय प्रस्तुति
❤❤🙏🙏
I AM SO HAPPY TO WATCH THIS VIDEO,
THANKS A LOT WITH MY DEEP HEART.
Thanks Alam sahab..God Bless You dear..Happy learning
your teaching is very nice.
Thanks Sanjiv ji
Very good knowledge thank you
Explanation is very clear sir, with your lecture not only learning the function, also learning how to think logically it is very clear thanks for your lecture.
Thanks Abdul Saleem Sahab
You are awesome👍 very useful . not only this but all videos are very knowledgeable. Thankuu sir
Thanks Sonia for your valuable appreciation dear..God bless you..Happy learning ❤️❤️
it is really good video and explain thing logicaly. You are really clever and sharp in excel.
Thanks Dear.Keep Learning
Heartfelt Dua for you Brother ❤ from Bangladesh 🇧🇩
Love you dear.
thanks for your valuable appreciation.. Really means. A lot to me
Behtareen...........🙏🙏🙏
Lots of respect
Thanks Vandana.Really means a lot to me.Recommend you to start your learning journey from playlist Basic Excel onwards (Videos in sequence playlist link given in Latest videos description)
Thanks for being part of Innozant family.Happy Learning❤🙏
@@Innozant Sir.. I m watching all ur videos and learning best tricks from you... Thanks for recommendation..
Keep sharing this unbeatable knowledge with us...
Thanks to you and your channel...🙏
Amazing video sir 👍👍👍
Maza aa gya video dekhke
Thanks dear...Keep learning
Amazing tricks sir . 👏 . We enjoyed your video on you tube. Our knowledge is enhance day by day by following your channel . Stay healthy and stay blessed. 🙏
Thanks Kapil Ji..God bless You..Keep learning ❤️
very very well tricks very nice
Very nice logic sir
Thanks Manoj Ji
Excellent ❤❤❤
Awesome trick sir.
Thanks🌹❤🙏 bhaya
So Nice Logic.. Thank you Sir...
Thanks Vinay ❤️🙏
Thank you...and you explain with a beautiful smile. Keep smiling.
Thanks Rajneesh
Excellent sir
You are outstanding sir 👌👌🙏🙏
Thanks 👍
just looking like a wow
You are just excellent
Thanks Om
Bahot shaandar sir. Bahot pasand aaya mujhe. Sir ek sawal tha ki ye doller sign k baad itne jyada space k baad value q populate ho rakhi he
Kahan par ..? formatting issue hai
Super 👍
Great sir...👍
Thanks ❤️♥️
Sir ji aap ka har video pasand hai aur like tho zaroor bantha hai in advance .. last wala example thoda hard hai .. Sir ji aur bhi kuch easy example bathai ye na please.. logic clear nahi ho paya.. thank you .
best channel
Thanks Devender
Hi I am learning excel from 3 months by myself and the channel which I was watching earlier was chandoo ( if you know who is he then yes ) now I realised I should have watch ur videos first now coming to query
Why didn't we direvtly writer "
Sorry now I realised that we have to copy paste the formula below and other months would not have same number of days or I can say other months would not have 30th as last day
U r explaining v good but ur question r very difficilt
Its not tough Dear.. Recommend you to learn frok Basic Excel 1st video onwards step by step m
Hello,
As you used EOM function, how can we do it for end of week ?
Sir ek question h apne creteria 1 me jo greater than equal to 1 aprl 2019 liya h to vo date fr jitna b greater hoga 1 aprl 2019 se sara record check krega or same as 2nd creteria please btaiyega
You're really doing great sir 👍👍👍👍
Thanks Maneesh🙏👍❤️
@@Innozant You're always welcome🎉
Amazing video sir
absolutely fantastic
Thanks Sameera
@@Innozant Sir now a days everyone are teaching everything, but very few know the subject, and you mastered in excel. People need teachers like you. Thank you for educating people like me.
@@sameerabanu3115 Really means a lot to me Sameera
Nic trick sir ❤❤❤❤
Excellent 👌
a true guru.
Thanks dear
Very helpful 👍
🙏❤️❤️
Great!
Amazing Sir thanks
Superb sir...👍
Thanks Ajay Ji..step by step pehle Basic excel Complete kijiye phir advance sorting onwards ...🙏♥️👍
Sir,pls finished vlookup video bz I am eagerly waiting for arey formula then excel course will be done.i am sure that you will do it asap.
🙏🙏🙏 Guruji
Yes... Indirect Series starts from tomorrow onwards 🙏🙏
Bhot bdia
Sir samjh me yo agaya.. Lekin criteria apne pehle product ko ku liya. Month ko ku nahii
sir can i do this with datevalue formula pls answer
Thank you for uploading useful videos, regarding this particular tutorial, I stuck where the amount column imported as text instead of a number so applying the function not giving any output, so if you can suggest a way to fix the issue. Thank you again.
I have multiple condition for sumifs e.g values (+invoice -Crecit note-payment-adjustment), I want to formulation in single way without cell selection. pls advice.
Thnx u too much 😊
Sir please tell me jo app Apr 2019,may 2019 text me likhe hai
Wonderful thanks Sir
Thanks dear
Hello Sir, Can we use "Text" Function in Sumif?
Awesome explanations sir i have a one doubt aapne jo ending me freez ka bataya vo kaise krna h
Using F4..
Freez krke dekha sir maine meri value sirf 1 cell me hi aa rhi hai sare cell me nhi aa rhi
Osum🙏 Thanks sir
Thanks Bhagyabati😊❤️
Bahot hard tha ye . Confusion hi confusion 😁
Again recap...it's easy dear when you are able to understand the concept
@@Innozant date ka concept aapne sikhaya nahi tha sir isiliye nhi samaj aa raha .
Osum 👍
❤️❤️🙏
Sir please make a video on “ to find out MTD of given month for year 2022 vs 2023 using sumifs”
Just wowwwwwwwww... from where can i download the sheet in which you are performing?
Check video description..Link are there
most super sir🙏
🙏♥️🙂
@@Innozant ❤️
Great sir
Thanks dear❤️🙏
Just super
hi, if my data is in a separate workbook, then I am unable to get SUMIFS. does the function work in the same workbook?
I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?
Bahut top h
Thanks Panku❤️🙏
Keep it up sir. Vba require
Thaka..Sure
Thnq sir so much
Sir may AP ka friend ho AP ki video like krta ho AP cube ka formula btay may Pakistan say ho plz reply
Sir ji what is the easy way to learn excel conceptual .. should i learn any basic programming? I have been using sap all the time where i dont use much excel . Recently realised that I have to learn excel for my accounting work where i can easily use most of the easy functions however i am not able to think conceptually the way you have showed in the last example, it seems easy when i see your video however i doubt whether i can think the way you think . How to build the concept in Excel..
fantasitc
sir i have question that is why i use > or < or = into the inverted commas in sumif and sumifs function bt the another thing is in sumproduct function do not use > < or = into the inverted commas.what is the reason behind it.which function i use inverted commas where not.plz explain sir.
Chandan Sahab jab Kisi condition ke Saath Kuch aur associate karna HOTA hai Jaise ki ">"&A1 (date between) Ka sum chaiye man lo to sumif me Aise use krte h..jabki sumproduct me to direct range= conditiin lagate Hain to whana concatenate krne ke jagah (A1:A10=condition). Aise pass kr dete h yahan jarurat nhi hai.
Telegram I'd join kariye koi query ho to..will discuss..
Telegram @innozantofficial
Aap kuch exercises bhi bata dete khud e karne ke liye to or acchi practice ho jati .
Dear Pushpak Kindly Watch Playlist -Proquest
Its assignment series dear
sir sumproduct sekaise hoga
How to possible we use sumif function but this sum value automatically change with filter
Sir Macro ki video bhi daliye..i need this
step by step aayega time ke saath dear
Sir in this video you have mentioned April ka month show karane ke lia toh sir 30 april show karne ke lia humne aise kyu nahi kara "
Krati aise paas krenge criteria to ye static approach hua na dear..isliye cell refe liya h na
@@Innozant okay got it !
AAP ITNE tech friendly insaan hai fir practice sheets ki google drive ese kyu thama di students ko ki khud dhunde konsi video ka excel kahan pe.
Hahaha..dear wo sab seprate hi the pehle,but folder delete ho jane ki wajahse dubara link playlist wise dena hua..kyunki 700+ videos hain itna possible nhi hai seprate link banana
Sir i tried this sumifs on the data which is having the heading of rows and coloumns , but i didn't
Product Dept April may june
cycle student 20 12 13
book class 30 41 34
pen class 33 23 34
book student 42 24 15
pen student 21 44 13
April Student Class
Cycle
Book
Pen
First try to organize the data as seems it is not organized then apply formula
Nice Sir, Sir i want you solve my query is, Sales person same but route is more of 2 in vertical, but date is horizontal with datewise sales amount & products in different array. how i find different date wise sum of sales person amount? please make a video these type question . i wait .......
Aap Apne data sheet Ka format bhejna with requirement,Bana dunga is topic par video.apka Ques samajh nhi aa Raha hai dear abhi🙏♥️
@@Innozant Sir, mail id de dijiye 🙏
Telegram I'd pat bhej skte Hain @innozantofficial
Sir is video ka sumproduct me solution video kab ayega
Already hai sumproduct me solution kiya hua dear
@@Innozant where Sir, need sumproduct solution as well. the practice file only has values, no sumproduct applied formula in sheet