Aap ke padaane ka tarika nayaab hai Sir. It's so energetic and full concepts clearing in multiple ways. Aap itni mahenat karte hein, taarife kaabil hai. Voice, speed command top it all teaching with smiling face and confidence. 👏👏👏👏👏🙏
Sir aapko salute hai kauki aap jo function ya formula padate hai wo sab excelant hai aapka excel me koi comparisons nahi ho sakta because your teachings is very simple style thank you very much sir
Sir yadi mere tebal mai kuch name h or mai un names ka count ya sum krna chahta hu jo kisi specific alphabet se start h ya koi specific alphabet us names mai kisi bhi place pr h tao sumproduct kese use kre please give me solution
Sir sumproduct as a COUNTA jo aap ne use kiya h.. Wo mujhe galat lag raha h... Ise hum jb use kr rhe he... Actually me to ye as a count kam kr raha he.... Output sahi isliye aa raha h kiu ki apne koi cell blank chora hi nhi tha (a3:a9) tak.. Agar koi cell blank hota to mere kheyal se to output galat ata sumproduct as a COUNTA 🤷🏼♂️... Kya me shi hu? Ya galat??.. Plz sir jarur bataiyega.. Aap bohot achha sikhate h sir... It's really added so much value in my life... ❤thank you so much sir 🙏💕..
Sir I am finding difficulty in applying sumproduct by adding two coloumn grater than say 49 in which there is error in some data i.e. no number in one coloumn so how we can avoid or bypass this error
मजा आ गया sir अपने शब्दों में वर्णन नहीं कर सकते हैं बस इसी तरह का xlookup फॉर्मूला को भी बता दीजिएगा तो अति उत्तम हो जाएगा sir आपको नमन बंधन सब करते हैं इस comment को पढ़ें और मेरे सबल पर गौर फरमाएं 🙏🙏🙏🙏
Thanks Pradeep🙏❤️After completion of excel will start Power BI and VBA as well.If you want ti start now then you may join our Live classroom training for sql and vba
6:28 sir, jb multiply krte h sumproduct me tb 1 bar hi quaers lgana hota h kya. aur jb comma lga ke krte h to dono range ke sath quaers lgana hota h kya?
yes fir apne ye bat btayi thi previous videos me. but isi series ki next video me jb apne average if use kiya to apne usme numerator sumproduct ko jb sum if ki trh use kiye to vha pe apne numerator me coerce nhi lgaya jbki denominator me jha apne countif ki trh sumproduct ko use kiya vha pe apne coerce lgaya. jbki ye video ka sum if aur us video ka sum if same h. fir dono video me apne sum if ki trh sumproduct ko use krne me itta alg kyo kiya. confusion hori h sir 😟 please check next video to this part in which you have compared sumprpduct with averageif
Ishu aap situation ko smjhaiye Jaise ki ydi koi aisa condition jisme group paas Kiya ho I mean array constant ho wahan coerce krne ya * use krne ka alag perspective hai Jis bhi topic me confusion jyada lag ra ho app ek Saath query apni ikatha Kar lijiye aur time ke Lena aap main Live connect krke via zoom apke wo doubt clear or dunga .👍❤️
@@Innozant sir video call me to comfortable nhi hu me. agr aap isi topic se related ki coerce kha use krna h kha nhi aur mere ye doubts ko leke ek dedicated video isi playlist me add krde to mere jese aur logo ke doubt bhi clear ho jayenge sir.baki apko bhi pta hoga sir ki mere ye doubts kyo are h.apne sumif vali video me alg aur averageif wali video me alg sumproduct use kiya h to confusion to hogi hi.mere jese aur bhi log honge sir agr ap time nikal ke kbhi ek dedicated video bna doto bdi meherbani hogi. 🙏
Ishu Meri Live class Hoti hai group of students ke Saath zoom meeting ..aapko video call par rehne ki jrurat nhi hai dear 🙂aap apni query puch sakte hain Jaise aur Candidate puchte Hain. Ok sumproduct Ka ek video aur bna dunga main Jo bhi doubt Hai user related time milta hai to. happy Learning 👍
for multiple conditions in SumProduct, what is the difference between a comma and multiple Sign, because if we use a comma instead of multiple sign then produce the same answer.
Sir Your Teaching Mindblowing. I love your all videos. I learned lots your videos. Sir You are very different really. God bless u. Keep smiling always 😊🌠
@@Innozant Sir man bohot chota tha aur mujhe bachpan se hi education haasil kernay ka bohot shoq tha raat ko full sardi man egg sale kiya kerta tha aur subha school jaya kerta tha aur jo paise kamata tha usse gher ka kharcha aur school ki fees pay kerta tha to us waqt mere ek teacher nay kaha tha k ek bat zindgi man yad rakhna k, jis bat ya kaam ka koye bunyaad na ho usko chor do, tab se aj tak man basic cheezo ko achay se samajhnay ki try kerta rehta hon bus.
Haan Bina motivation ke wo power kahan..🙏❤️🙂Keep supporting..Faila dijiye apne friends group me sabke.boliye kuch seekh dhanga ka..ya fees Deke hi seekhne me jyada sukun to wo bhi optiona hai😀😍
@@Innozant sir telegram pr is naam ka koi bhi group available nhi h Maine jab bhi search kiya mughe no results found show hota h please share your mobile number if search easily
Sir, Kuch mind na kariye, main apse Bohot kush Sikha hun Free main, Apne hi bola tha "jaha '*' use hote hain, waha '--'(quates) ka zarurat nahi", lekin ap multiple condition pe '*' dene ka wavujut quates use kar rahen hain, Kya Iska koi special Karan Hain? main apka rules follow karte huein ja ra hu, such meain dekha hu ap jaha jaha quates and '*' use karte hein, waha only '*' se kam ho jata hain. Please, Sir iska koin specail karan hain, to please bata dejiye, Thank You Sir !
You must have studied hard and practised hard that's why you can explain it in such an effortless way. You are legend in Ms Excel❤
Thanks.Really means a lot to me
Not just this one, every video you have made in the past as well, is really informative. Keep up the good work.
Thanks dear.Really means a lot to me
bahut bahut dhanyvad sir, mai sabhi ko suggest karta hu aapki vedio
Thanks Rashid 👍❤️
Apka to samjhane ka Jo tarika hai bilkul jawab nahi hai ❤❤❤❤❤
Thanks
thanks sir i learn with your vedio
Aap ke padaane ka tarika nayaab hai Sir. It's so energetic and full concepts clearing in multiple ways. Aap itni mahenat karte hein, taarife kaabil hai. Voice, speed command top it all teaching with smiling face and confidence. 👏👏👏👏👏🙏
Thanks for your valuable appreciation.. Really means a lot to me.
Sir aapko salute hai kauki aap jo function ya formula padate hai wo sab excelant hai aapka excel me koi comparisons nahi ho sakta because your teachings is very simple style thank you very much sir
Thanks Pramod ji itne pyare aur valuable comment ke liye,Aisi videos aur study ,Skill enhancement aapki humesha hoti rhe aisa humesha koshish rahega mera.🙏❤️🙂
You are Good teacher sir
🙏 PRANAM SIR 🙏
बहुत बढ़िया सरजी मजबूत हो रहा हूँ मैं सम प्रोडक्ट में ।
Good 👍
This is the best video ever on sum product. Thanks a lot GURU,,,🙂
Thanks dear..Happy Learning
@@Innozant sir why you are using Coarse( 2 minus symbols)
When you are already using * symbol between two arrays
Thank you sir. Mujhe itna sab sumproduct ke baare Mai nHi pta tha.
Ab pta chl gya Sir. Thank you Sir
Array and Sumproduct ka video series dekhiye complete playlist .bht advantage hain uske
Nice sir ab samajh Aaya only one sumproduct used .❤️❤️
Thanks Md Riyaj❤️
Very informative video Sir ji. You always enhance the capacity of thinking regarding Excel by your videos 🙏
Thanks Harivansh Gautam ji for such a valuable feedback,Will always try to make awesome videos.🙏❤️
best channel, very clear and concise
Thanks dear❤️🙏
Sir yadi mere tebal mai kuch name h or mai un names ka count ya sum krna chahta hu jo kisi specific alphabet se start h ya koi specific alphabet us names mai kisi bhi place pr h tao sumproduct kese use kre please give me solution
Tnk u sir for sharing the knowledge for free.... literally tnk u so very much 🤗 May god bless u😇
Thanks Pankaj ji God bless you.Happy learning
Thanks you sir, through this we learn real use of sumproduct.
Thanks Hemant Ji..🙏❤️🙂Gn
Aa! Aa! Ha! Mind blowing! Very interesting!!!!
Thanks Vijay Kumar Ji❤️
Good sir je sum product mere abb bohat kam ayega thnq sir
Ok.thats Good.
sir. i am thankful to get a teacher like you. you make everything so simple,
Thanks Isha .Hope you are fine and Doing well in your life . Wishing you wonderful career ahead..God bles you❤️❤️
Awesome Video Sir ji.
I love your efforts and consistency 💖🙏....
Thnks,m trying my best to deliver awesome content 🙏❤️🙂
Nice Sir, A way to simply understand👍
Thanks Yogesh Ji🙏❤️🙂
Sir mai sumproduct se range lekar aur jab pos value se multiply karta hu to hamesha #VALUE! Error dikhata hai. Sumifs or sumif se sahi figs aati hai
Hi sir
Mere pass ek if condition hai use extend karana hai lekin samaj nahi aa raha hai kaise kare kya aap help karoge.
Thank you so much for this video, it is really very helpful. 😊
Sir sumproduct as a COUNTA jo aap ne use kiya h.. Wo mujhe galat lag raha h... Ise hum jb use kr rhe he... Actually me to ye as a count kam kr raha he.... Output sahi isliye aa raha h kiu ki apne koi cell blank chora hi nhi tha (a3:a9) tak.. Agar koi cell blank hota to mere kheyal se to output galat ata sumproduct as a COUNTA 🤷🏼♂️...
Kya me shi hu? Ya galat??.. Plz sir jarur bataiyega..
Aap bohot achha sikhate h sir... It's really added so much value in my life... ❤thank you so much sir 🙏💕..
Sir tell the index match function formula on big data
Awesome explanation. Many thanks.
Thanks dear ❤️
Sir sumproduct function using as a counta is not working properly
Sir, how to get rate by #sumproduct, from multiple criteria
Sir Dout ha Ek Table ha Jisma 3 colum ha jisma muja 3 column ma 100 ka value pata kar na kon sa formula laga na ha
thanks, great help for me today
I have watched more than 5 hours in two days bcz this is a great channel for excel lovers ...
Now innozant channel is my favorite and you as well.
Thanks Mahesh ji.Recommend you to start your learning journey step by step (videos in a sequence playlist link provided in video description)
Sir kindly upload more about array method and upto basic
Sir *multiple sign use kre ya ,commma sumproduct(--(array1=criteria), sumrange
Jab range common na ho to multiply otherwise comma🙏❤️sumproduct advantage ka video teeno dekhiye..detail me smjhaya hua h
COUNTA func counts all non-blank cells including errors as well. something SUMPRODUCT is not able to do. Pls add this detail as well.
Sir share your life experience like how did you learn Excel and other tools , share your career journey, please it will be motivation for all. 🙏🙏🙏
Thanks Suraj ...
Kar diye hain Malik ....
Sir countif formula with filter data kse use kre
Sir I am finding difficulty in applying sumproduct by adding two coloumn grater than say 49 in which there is error in some data i.e. no number in one coloumn so how we can avoid or bypass this error
मजा आ गया sir अपने शब्दों में वर्णन नहीं कर सकते हैं बस इसी तरह का xlookup फॉर्मूला को भी बता दीजिएगा तो अति उत्तम हो जाएगा sir आपको नमन बंधन सब करते हैं इस comment को पढ़ें और मेरे सबल पर गौर फरमाएं 🙏🙏🙏🙏
Office 365 playlist dekhiye 👍
How to find the count of Unique Emp ID that is hold by individual EmpName?
As "A" is having 2 unique Emp ID...
Sir, ky ye possible h ki agr hum sumproduct ki help se sirf aise names ko extract krke laaye jiska name "pri" se start ho
Awesome Sir
Pls help ...need to count unique A/c based on TXn month and A/c activation month
=SUM (1/COUNIIFS ()
IS UNIQUE COUNT KO MUJHE FILTER LAGANE KA BAAD BHI VISIBLE DATA PAR KAAM KARE KYA FORMULA HOGA PLEASE BATAYE
Nice videos sir,, really thankful to you...🙏🙏
Thanks Litesh Ji
Bahut badhiya sir
Thanks Ravi..🙏❤️
Hello are you there? Can i ask one question on this topic?
Sir sum product with countif is rank kasaia nekaloo gay
Excellent sir 👌👌
Thanks Manoj ji
superb sir 👍🏻👍🏻👍🏻👍🏻
Lots of thanks
Thanks a lot.
Really u r the best teacher in excel.
I want to learn about VBA pls help me
Thanks Pradeep🙏❤️After completion of excel will start Power BI and VBA as well.If you want ti start now then you may join our Live classroom training for sql and vba
Thanks Sir
❤️❤️
Love this video
Excellent!
6:28
sir, jb multiply krte h sumproduct me tb 1 bar hi quaers lgana hota h kya.
aur jb comma lga ke krte h to dono range ke sath quaers lgana hota h kya?
Haan Ishu,jab condition seprate hota hai to harek conditions se pehle coerce krenge nhi to multiple Ka sign use or skte h coerce ki jagah🙏❤️
yes fir apne ye bat btayi thi previous videos me.
but isi series ki next video me jb apne average if use kiya to apne usme numerator sumproduct ko jb sum if ki trh use kiye to vha pe apne numerator me coerce nhi lgaya jbki denominator me jha apne countif ki trh sumproduct ko use kiya vha pe apne coerce lgaya.
jbki ye video ka sum if aur us video ka sum if same h.
fir dono video me apne sum if ki trh sumproduct ko use krne me itta alg kyo kiya.
confusion hori h sir 😟
please check next video to this part in which you have compared sumprpduct with averageif
Ishu aap situation ko smjhaiye Jaise ki ydi koi aisa condition jisme group paas Kiya ho I mean array constant ho wahan coerce krne ya * use krne ka alag perspective hai
Jis bhi topic me confusion jyada lag ra ho app ek Saath query apni ikatha Kar lijiye aur time ke Lena aap main Live connect krke via zoom apke wo doubt clear or dunga .👍❤️
@@Innozant
sir video call me to comfortable nhi hu me.
agr aap isi topic se related ki coerce kha use krna h kha nhi aur mere ye doubts ko leke ek dedicated video isi playlist me add krde to mere jese aur logo ke doubt bhi clear ho jayenge sir.baki apko bhi pta hoga sir ki mere ye doubts kyo are h.apne sumif vali video me alg aur averageif wali video me alg sumproduct use kiya h to confusion to hogi hi.mere jese aur bhi log honge sir agr ap time nikal ke kbhi ek dedicated video bna doto bdi meherbani hogi. 🙏
Ishu Meri Live class Hoti hai group of students ke Saath zoom meeting ..aapko video call par rehne ki jrurat nhi hai dear 🙂aap apni query puch sakte hain Jaise aur Candidate puchte Hain.
Ok sumproduct Ka ek video aur bna dunga main Jo bhi doubt Hai user related time milta hai to. happy Learning 👍
Sir ji very nice 🤩
Thanks Dear Sanoj
Excellent. Very interesting. Thank you.
Thanks Sir..Hv a great weekend.🙏🙂
@@Innozant Thank you. I want your mailid to send the file for a solution. Please share
innozantcampus@gmail.com
wonderful
Very nice
Sir sumproduct se great kese nikalta hy us ka bhi koi example bataen thanks
Grade?..ok..bana denge dear
2d sum can do by sumif or sumifs
When we have set of conditions use sumifs
Great great sir
Thanks dear ❤️🙏
I want operation for sumproduct formula please I request u
=SUMPRODUCT(--(EmpName""))
sir count a k liye yeh formula bhi thik hai na
Yes
Excellent
Thanks Jai
for multiple conditions in SumProduct, what is the difference between a comma and multiple Sign, because if we use a comma instead of multiple sign then produce the same answer.
when dimention is different then use * else --
Sir aapne excel maati institute se sikha hai kya..
NO Sharma Ji,Course to maine kahin se nhi kiya hai.Seekhane ka kaam hai mera aur Khudse apni skills enhance karne ka.🙏❤️
Sir quaers means if condition is true they convert to 1 and false convert to 0 in sumproduct Thanku sir good night.🙏🙏🙏
Yes Very Good.🙏❤️🙂M happy that you never miss to watch a single video..daily you learn then sleep..Good going.Gn
Thank you sir
❤🌹😊
Thanks Ravi Ji❤🙏
Maje hi aa gaye yaar
Thanks
Great video thx
Thanks Radhe❤️
Superior in Excel
Thanks Arshad
Sir Your Teaching Mindblowing. I love your all videos. I learned lots your videos. Sir You are very different really. God bless u. Keep smiling always 😊🌠
Thanks Sandeep,These lovely feedback is reason of my motivation dear.God bless you🙏❤️🙂
Great 👍👍
First view sir nd amezing quotes for true false
🙏❤️Thanks Lokesh ..Yes more video uploading soon for Sumproduct vs other formula
Taki hum bhi abse bs sumproduct use kre
Super sir
Thanks Negi Ji..Happy learning
Sir please make videos on TABLEAU.
WISHING FOR A HEART
Taleau to abhi nhi..but soon we start Power series...Power query,power view,power map,power pivot and power BI🙏❤️
You have win my hurt ,realy
Thanks dear❤️👍
Sumproduct se sara hal kre jha par vlookup sumit counting etc sumproduct ki series start kre
Soon you may see more videos of sumproduct vs other function🙏❤️🙂
@@Innozant sir acha lga kuch nya seekhne ne ko mila. Aise vlookup, average etc . Solve by sumproduct formula.
Q k man apka bohot bara fan hon i love you sir very much.
Thanks dear ❤️😌
@@Innozant Sir man apka dil se shukriya ada kerta hon k aj apka bataya huwa method ki waja se man sirf ek funktion se saaray kaam ker sakta hon.
@@Innozant Sir man bohot chota tha aur mujhe bachpan se hi education haasil kernay ka bohot shoq tha raat ko full sardi man egg sale kiya kerta tha aur subha school jaya kerta tha aur jo paise kamata tha usse gher ka kharcha aur school ki fees pay kerta tha to us waqt mere ek teacher nay kaha tha k ek bat zindgi man yad rakhna k, jis bat ya kaam ka koye bunyaad na ho usko chor do, tab se aj tak man basic cheezo ko achay se samajhnay ki try kerta rehta hon bus.
@@Innozant Ap jo basic cheez batatay hai bohot amazing hoti hai, i proud of you sir.
Array with Lookup Funtions ke videos banao sir,
Already hain dear..Videos array with lookup
Great!
How to count unique value of repeated value with multiple criteria? please.
Using countif find occurance of repeated content then count it
Superb
Thanks Naeem sahab🙏❤️
I have a question of sumproduct. Can u solve please
@innozantofficial telegram id.🙏❤️
@@Innozant I don't have tellgram id
Nice
GREAT
🙏❤️
Interesting
Thanks Aqeel..Lo last me ek ques pucha hai Maine wo jarur attempt kijiye aur formula comment kariye mujhe
sir power query series shuru karo
Soon..Power pivot,Power Query,Power view,Power map then power BI complete course step by step we are going to introduce.
Ab pta chal Power of sumproduct
plz subscribe kare like kare q k thoda motivation to sir ko bhi chahiye 🙏😊
Haan Bina motivation ke wo power kahan..🙏❤️🙂Keep supporting..Faila dijiye apne friends group me sabke.boliye kuch seekh dhanga ka..ya fees Deke hi seekhne me jyada sukun to wo bhi optiona hai😀😍
@@Innozant 😂🤣
Sir telegram show nhi ho rha aapka
@innozantofficial
@@Innozant sir telegram pr is naam ka koi bhi group available nhi h
Maine jab bhi search kiya mughe no results found show hota h please share your mobile number if search easily
सर अब आप VBA पर भी विडियो बनाये हमें इंतजार रहेगा
Haan jarur bnayenge dear
Sir, Kuch mind na kariye, main apse Bohot kush Sikha hun Free main, Apne hi bola tha "jaha '*' use hote hain, waha '--'(quates) ka zarurat nahi", lekin ap multiple condition pe '*' dene ka wavujut quates use kar rahen hain, Kya Iska koi special Karan Hain?
main apka rules follow karte huein ja ra hu, such meain dekha hu ap jaha jaha quates and '*' use karte hein, waha only '*' se kam ho jata hain.
Please, Sir iska koin specail karan hain, to please bata dejiye, Thank You Sir !
Asterisk lagane ka benifit ye hai ki range agar same nhi bhi hoga to koi issue nhi hai -- negative true ko 1aur false ko 0 krega
Bus =sum(--( aagay ap jo kerna chahay ker saktay hai ye tricks bhi ap ne hi bataya tha.
👍❤️
How to sum between month
please find solution in Array & sumproduct Playlist vidieos
Sir ( sumproduct=(--( ) dubbel minus ka samaj me nahi agar video ho to link do jise dekh kar samaj jau sir baki sir awesome
Sumproduct ka to pura series hai dear..array and sumproduct playlist me jake dekhiye -- coerce ke upar pura ek video hai dear.