Superb SHANDAR Dil se tareef sir... Dil se tareef karni pad ri h TH-cam par shyad hi mene aise comment kiya ho par Aapke Video Ko dekh ke itna acha laga ki me khud ko comment karne se rok ni paya... Superb SHANDAR... Sir The way you teach its superb. Thanku...
Mai aap ke video mai accidentally aa gaya. Mai sumproduct formula ke liye video search kar raha tha mujhe kuch confusion tha regarding (-- )or ( * ) in dono mai se kiska use kab or kyu karte hai. Aab sayad iska answer mil gaya hai mai aab practice kar ke dekhun ga. Aap agar in dono par (--) or (*) details se video banaye ge to mere jaise bahut se student ka doubt clear hoga . Mere jaise bahut se student hai jinhe ( --) or (* ) is me confusion rehta hai.
Dear sir as kindly add #learnexcelinhindi har formula Hindi use karna ..aapki Rich kafi badani chahiye ..A1 quality videos ...lots of love and respect ❤️
Thank you was finding this, What if someone is having diffrent product Variations, Like Product 1/Product 1a/Product 1b and so on, How to get sum of Product 1 including all variations ?
Explanation is excellent. I have used this for years, but first time came to know what parameters to use. One question I have is, when you used AND (*) you did not use (--). Why so? You used that in OR only.
Sir 1 table mai 6 item hai unka commission nikalna hai 4 other conditions ke sath unme 4 alag alag outlet hai, plus 6 item ke alag alag % hai, alag alag outlet mai??
Sir your teaching skilled is great but have to improve video quality pixel. Other wise it's awesome. It's a request to improve video quality so the visibility is clear.
Sir, can you please tell how to write the formula for finding partial match inside a sumproduct formula (instead of writing fully need to type as " Fari" for Faridabad) also how to write by referring a cell having "Fari". This will be very useful.
Sir your way of teaching excellent.sir in and condition double minus sign kiu use nahi kia gaya bracket sa bahir sumproduct formula Mai jab colum separate ho
Hello Ahmed ji, thanks for your comment. This is really a very good question! Humne double negative use karne ki jarurate nahi padi because we are multiple both ranges like this (A6:A25=I7)*(B6:B25=I8). Jab bhi hum range ko multiply karte hai then double negative ki jarurate nahi padti kyuki agar app FALSE * FALSE karoge to you will get 0 and TRUE * TRUE kagoge to 1 milega. Double negatives ko tabhi use karna hai jab ya to ek range ho ya fir dono range me comma ho like this (A6:A25=I7),(B6:B25=I8) I hope, we answered your question.
Hello! Sir, this is nice example & i appreciate your effort here. but i have that contains upto 9 month data for different product (i.e inbound: case receiving, Outbound : case receivingetc... ) & i need to extract the qty & amount for certain product for certain month. I tried with sumproduct but didn't get the out put. I got the total of qty for january, but now i need to break it down in product. how can i do it? Because the data has inbound, outbound & sub category will be case receiving, inbound bar coding, pallet receiving like that. I appreciate your answer if you can solve my query
Hi Dipali, here you need to extract the data based on some conditions. So it's better to use the SUMIFS formula. We have shared the solution file with you via email.
answer to the homework problem is "2"-- =SUMPRODUCT((B6:B25=I21)*(C6:C25=I22)) you can verify it using countifs function also, =COUNTIFS(B6:B25,I21,C6:C25,I22) and if you want to flex, (like me😁😁) then, =COUNTIFS(B6:B25,INDEX(B6:B25,MATCH(I21,B6:B25,0)),C6:C25,INDEX(C6:C25,MATCH(I22,C6:C25,0))) =COUNTIFS(B6:B25,VLOOKUP(I21,B6:B25,1,0),C6:C25,VLOOKUP(I22,C6:C25,1,0))
Sir double negetive sign samjh me agaya mere true ko 1 or false ko 0 karta hai... Jab apne delhi or up ka value nikala tab double negetive use kara okk... Lekin jese hii apne tiisra solution kara usme apne double negetive use nahii kara jesa kii apne bataya hai k text ko Multyply nahii kar sakte value ko.. To third solution me bhii to text tha to ku nahii kara apne negetive sign use... Baki sab samjh me agaya buss yahii confusion nahii ho raha mera clear
Sorry sir wo 4th solution tha.. Jisme apne category or location kii jo baat kari hai usme apne double negative use nahii kara hai.. Jabki usme text hai..
For Total sales for Category C and location UP apne -- use nhi kiya fir bhi answer agaya aisa kaise hua? (just because apne array="C" ki jagah cell location di uski wajah se ya is there any other reason?)
Hello dk, this is really a very good question! Humne double negative use karne ki jarurate nahi padi because we are multiple both ranges like this (A6:A25=I7)*(B6:B25=I8). Jab bhi hum range ko multiply karte hai then double negative ki jarurate nahi padti kyuki agar app FALSE * FALSE karoge to you will get 0 and TRUE * TRUE kagoge to 1 milega. Double negatives ko tabhi use karna hai jab ya to ek range ho ya fir dono range me comma ho like this (A6:A25=I7),(B6:B25=I8) I hope, we answered your question.
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
ok
too good trick thanks for sharing valuable excel trick
Thank you Kalyan Singh Bisht!
Wow very helpfull in this video,,, Thanks a lot of Brother
Superb
SHANDAR
Dil se tareef sir... Dil se tareef karni pad ri h
TH-cam par shyad hi mene aise comment kiya ho par
Aapke Video Ko dekh ke itna acha laga ki me khud ko comment karne se rok ni paya...
Superb SHANDAR...
Sir The way you teach its superb.
Thanku...
Thank you manishbohra2588 ji. Your comments motivate us to create more videos. Thank you for watching our videos!
First time, and your teaching technique and skills are superb...thanks a lot for the learning.
Bhot acha video sir . Bhot achhe se smjhaya apne
Thank you Anujkumar for watching our knowledgeable videos!
sum product ka concept aaj jake clear hua hai. Thank you sir.
GREAT BOSS. EXCELLENT KNOWLEDGE AND EXPLAINATION
Thank you, Sonu ji!
Really very clear easy to understand very well teaching Your really good
Sir very useful video
Thank you!
Finally I learn something new here compared to others channels 🙌 👏 🙏 thanks Sirji😇
Thank you, Brijesh Ji! '👍
Very nice explanation, step by step from beginner
say advance ka presentation bhaut acha hai apka - 100% likes for you
Thanks Prateek. We are just trying ke simple langauge me concept ko samjha sake.
Sir aap se achha koi nahi samjhata pure TH-cam par thanks
Bhai wakayi me agar tujhe samjh me agay to bata.. 4th number ka jo solution nikala th a usme double negetive sign use ku nahii kara
Best teacher sir 👌 and best topic. You solved my all of my work problems.
Thank you Mohsin, you made our day!!
Mai aap ke video mai accidentally aa gaya. Mai sumproduct formula ke liye video search kar raha tha mujhe kuch confusion tha regarding (-- )or ( * ) in dono mai se kiska use kab or kyu karte hai. Aab sayad iska answer mil gaya hai mai aab practice kar ke dekhun ga. Aap agar in dono par (--) or (*) details se video banaye ge to mere jaise bahut se student ka doubt clear hoga . Mere jaise bahut se student hai jinhe ( --) or (* ) is me confusion rehta hai.
very well explained, easy to understand the SUMPRODUCT formulae
Thank you Navneet!
You are the best teacher ❤ ever . 🙏🙏🙏🙏
Perfect & nice teaching
Thank you, Ramesh ji, for watching our videos!
Thank you sir i was able to solve different interview question from the help of this video
Your welcome Ranger!
Sir thanks a lot. interactive teaching method.
Thanks, Awadhesh for liking the video!
Amazing explanation. Wonderful 👍
Thank you!
Wow superb sir, you nailed the logic and taught such greatly...you efforts are god's grace help... Thank u for all ur videos n teaching
great, Thankyou
Excellent sir God bless you bhaijaan 🎉
Awesome Sir
Thanks for your video on this topics
Thanks, Manmohan, for watching our videos. My pleasure.!
Too Good. Thank you.
Thank you Swapan!
very informative and wll teached. Thanks a lot.
Amazing sir
Thanks bro ab ja k formula samaj main aya.
You're welcome, Hanif Khan!
Excellent ❤
Owesom bro, you have a good way to teach, Keep it up ❤
Thank you Rohit Kumar!
Sumproduct Best video ever ❤
Amazing tutor
excellent
Thanks Al Amin. Keep learning and sharing
I don't subscribe normally but you deserve ❤
Great sir🥰
Thank you!
Very nice
amaizing
Thank you!
Well explained ❤️
Thank you
You're welcome
Dear sir as kindly add #learnexcelinhindi har formula Hindi use karna ..aapki Rich kafi badani chahiye ..A1 quality videos ...lots of love and respect ❤️
Thanks Kadar for liking the video. Sure, I will keep it in mind. Don't forget to like and share the video with your friends.
Super
Thanks sir
Your welcome Sir!
❤❤❤❤❤❤❤❤❤❤❤Amagine
Thanks...
What an example
Thanks
Like it. Thanks
Thank you Ubaidillah Muhammad!
Can you please show us how to use subtotal and offset with sum product?
Wah,kamal
Thank you was finding this, What if someone is having diffrent product Variations, Like Product 1/Product 1a/Product 1b and so on, How to get sum of Product 1 including all variations ?
Explanation is excellent. I have used this for years, but first time came to know what parameters to use. One question I have is, when you used AND (*) you did not use (--). Why so? You used that in OR only.
Sir agar hmre pas total sale hai or hme 1 range mai se delhi up dono ki 1 sath sals niklni ho to sumif or sumifs se ni hoga ye
Sumif ke formula ke through ho jayega but you need to use SUM and SUMIF formula together with { } brackets.
हमें आपकी बहुत जरूरत है sir video upload kar diaa kijie please
I mostly use Google Sheets, do you have videos on that too? I am a heavy QUERY and INDEX/MATCH inquiry person.
Can we use if contains text in sumproduct formula
Swayampak, you can try that and see the results!
Sir 1 table mai 6 item hai unka commission nikalna hai
4 other conditions ke sath unme 4 alag alag outlet hai, plus 6 item ke alag alag % hai, alag alag outlet mai??
Sir your teaching skilled is great but have to improve video quality pixel. Other wise it's awesome. It's a request to improve video quality so the visibility is clear.
I think the video quality is good. But I will tell my team to work more on the quality part. Thank you for your feedback!!
Please share example for conditions in column and row at same time
Okay Rajat, we will try to create the similar example.
Sir Can u please share the sheet for practice. Please
Sir aap vidoe upload kyo nhi करते हैं अब
Sir, can you please tell how to write the formula for finding partial match inside a sumproduct formula (instead of writing fully need to type as " Fari" for Faridabad) also how to write by referring a cell having "Fari". This will be very useful.
The wildcards (*) can't be used in SUMPRODUCT formula. So, the above problem can be solved only by Sumifs formula.
At 16:33 , when you use both conditions, why don't you put --
Sir your way of teaching excellent.sir in and condition double minus sign kiu use nahi kia gaya bracket sa bahir sumproduct formula Mai jab colum separate ho
Hello Ahmed ji, thanks for your comment.
This is really a very good question! Humne double negative use karne ki jarurate nahi padi because we are multiple both ranges like this (A6:A25=I7)*(B6:B25=I8). Jab bhi hum range ko multiply karte hai then double negative ki jarurate nahi padti kyuki agar app FALSE * FALSE karoge to you will get 0 and TRUE * TRUE kagoge to 1 milega.
Double negatives ko tabhi use karna hai jab ya to ek range ho ya fir dono range me comma ho like this (A6:A25=I7),(B6:B25=I8)
I hope, we answered your question.
Hello! Sir, this is nice example & i appreciate your effort here. but i have that contains upto 9 month data for different product (i.e inbound: case receiving, Outbound : case receivingetc... ) & i need to extract the qty & amount for certain product for certain month. I tried with sumproduct but didn't get the out put. I got the total of qty for january, but now i need to break it down in product. how can i do it? Because the data has inbound, outbound & sub category will be case receiving, inbound bar coding, pallet receiving like that. I appreciate your answer if you can solve my query
Hi Dipali, here you need to extract the data based on some conditions. So it's better to use the SUMIFS formula. We have shared the solution file with you via email.
Mene is tarah se use kabhi nahi kiya tha pehle sum product ko
👍
Sir, sheet 1 ke 4th question me double negative kyu nahi use kie
Sir I want to learn SQL and
answer to the homework problem is "2"--
=SUMPRODUCT((B6:B25=I21)*(C6:C25=I22))
you can verify it using countifs function also,
=COUNTIFS(B6:B25,I21,C6:C25,I22)
and if you want to flex, (like me😁😁) then,
=COUNTIFS(B6:B25,INDEX(B6:B25,MATCH(I21,B6:B25,0)),C6:C25,INDEX(C6:C25,MATCH(I22,C6:C25,0)))
=COUNTIFS(B6:B25,VLOOKUP(I21,B6:B25,1,0),C6:C25,VLOOKUP(I22,C6:C25,1,0))
Sumproduct((categary=c)*(location=UP))
we could have used "*" between the Array selected to get the desired result, Isn't it??
Sir formula big size mein dikhaye
Okay Sanjay Ji, we will take care of it.
Sir double negetive sign samjh me agaya mere true ko 1 or false ko 0 karta hai... Jab apne delhi or up ka value nikala tab double negetive use kara okk... Lekin jese hii apne tiisra solution kara usme apne double negetive use nahii kara jesa kii apne bataya hai k text ko Multyply nahii kar sakte value ko.. To third solution me bhii to text tha to ku nahii kara apne negetive sign use... Baki sab samjh me agaya buss yahii confusion nahii ho raha mera clear
Sorry sir wo 4th solution tha.. Jisme apne category or location kii jo baat kari hai usme apne double negative use nahii kara hai.. Jabki usme text hai..
For Total sales for Category C and location UP apne -- use nhi kiya fir bhi answer agaya aisa kaise hua? (just because apne array="C" ki jagah cell location di uski wajah se ya is there any other reason?)
when you used AND (*) you did not use --. Why?
Same doubt
Great Bro❤
Thanks US..
Home work ka ans 1 hoga?? Koi bataye
15 min 14 sec double negative kyon nhi use kia gaya
Hello dk, this is really a very good question! Humne double negative use karne ki jarurate nahi padi because we are multiple both ranges like this (A6:A25=I7)*(B6:B25=I8). Jab bhi hum range ko multiply karte hai then double negative ki jarurate nahi padti kyuki agar app FALSE * FALSE karoge to you will get 0 and TRUE * TRUE kagoge to 1 milega.
Double negatives ko tabhi use karna hai jab ya to ek range ho ya fir dono range me comma ho like this (A6:A25=I7),(B6:B25=I8)
I hope, we answered your question.
Kabhi - - laga re , kabhi nhi laga re, kuch bhi matlb😂😂😂
very nice information ❤🩹❤🩹❤🩹
Thanks sir