Sumproduct Formula in multiple conditions (from basic to advanced) | sumproduct in hindi

Sumproduct is one of the important formulas in excel. As the name suggest, the sumproduct formula firstly multiply the multiple column values row by row and then provide the total of the entire column in a single cell.
Usually all of us use multiple columns for calculation purposes but excel sumproduct function works with arrays which means there is no need of adding multiple columns, here we get the result in a single cell. Sum product function in excel help us to save a lot of time. The sumproduct function in excel is the combination of product and sum in excel. Let's see how to use sumproduct with multiple criteria in hindi.🔥🔥🔥🔥🔥
What you will learn in this video:
✔️ What is sumproduct function in excel
✔️ How to apply sumproduct in excel hindi
✔️ how to use sumproduct formula in multiple conditions
✔️ Why to use excel sumproduct
▼ DOWNLOAD EXCEL FILE - mdatafinnovatics.com/Latest-A...
----------------◀◀◀ KZbin Playlist ▶▶▶------------
ADVANCED EXCEL LATEST VIDEOS - bit.ly/3tRuOJ5
EXCEL FORMULAS & FUNCTIONS - bit.ly/33lp6UZ
USE MULTIPLE FORMULAS TOGETHER - bit.ly/350p0Cy
EXCEL SHORTS | EXCEL TIPS & TRICKS - bit.ly/3nx2ojd
EXCEL TOOLS - bit.ly/350Dp1z
----------------▪▪◾◼◼Social Media ◼◼◾▪▪------------
WEBSITE LINK - www.mdatafinnovatics.com/
KZbin CHANNEL - kzbin.info...
FACEBOOK PAGE - / mdatafinnovaticsofficial
TWITTER PAGE - / mfinnovatics
INSTAGRAM PAGE - / mdatafinnovatics
COMPANY LINKEDIN PAGE - / mdatafinnovatics
QUORA - www.quora.com/profile/Pradeep...
----------------------⬅◀◼Blogs◼▶➡----------------------
How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - www.mdatafinnovatics.com/list...
---------------✉️✉️✉️Contact Us✉️✉️✉️--------------
EMAIL ADDRESS: [e-mail]
sumproduct in hindi
sumproduct excel in hindi
sumproduct excel
sumproduct formula
sumproduct with conditions
how to use sumproduct formula
sum product function
sumproduct formula in excel in hindi
sumproduct with multiple criteria
sumproduct with criteria
use sumproduct function in excel
sumproduct with multiple criteria in hindi
#mdatafinnovatics #sumproduct #sumproductformulainexcel #excelforIndia #sumproductformula

[@MDataFinnovatics]

Call us at [phone] for Advanced Excel LIVE Training, Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍

[@Deeparanjith1716]

Really very clear easy to understand very well teaching Your really good

[@brijeshshah574]

Finally I learn something new here compared to others channels 🙌 👏 🙏 thanks Sirji😇

[@MDataFinnovatics]

Thank you, Brijesh Ji! '👍

[@UdayKumar-gz2zs]

sum product ka concept aaj jake clear hua hai. Thank you sir.

[@mohammedashfar1466]

You are the best teacher ❤ ever . 🙏🙏🙏🙏

[@KuKu_247]

too good trick thanks for sharing valuable excel trick

[@MDataFinnovatics]

Thank you Kalyan Singh Bisht!

[@manishbohra2588]

Superb SHANDAR Dil se tareef sir... Dil se tareef karni pad ri h KZbin 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...

[@MDataFinnovatics]

Thank you manishbohra2588 ji. Your comments motivate us to create more videos. Thank you for watching our videos!

[@TinTin6261]

Very nice explanation, step by step from beginner say advance ka presentation bhaut acha hai apka - 100% likes for you

[@MDataFinnovatics]

Thanks Prateek. We are just trying ke simple langauge me concept ko samjha sake.

[@zoobihassan]

very informative and wll teached. Thanks a lot.

[@MohsinSWadekar]

Best teacher sir 👌 and best topic. You solved my all of my work problems.

[@MDataFinnovatics]

Thank you Mohsin, you made our day!!

[@Raji0818]

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

[@navneetkumar5790]

very well explained, easy to understand the SUMPRODUCT formulae

[@MDataFinnovatics]

Thank you Navneet!

[@sonuharipur]

GREAT BOSS. EXCELLENT KNOWLEDGE AND EXPLAINATION

[@MDataFinnovatics]

Thank you, Sonu ji!

[@sayyedshehwar3390]

Sir aap se achha koi nahi samjhata pure KZbin par thanks

[@AlimKhan-bl5sh]

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

[@FactFileNurd]

Thank you sir i was able to solve different interview question from the help of this video

[@MDataFinnovatics]

Your welcome Ranger!

[@Anujkumar-rv6wk]

Bhot acha video sir . Bhot achhe se smjhaya apne

[@MDataFinnovatics]

Thank you Anujkumar for watching our knowledgeable videos!

[@user-jc9th1ml1h]

great, Thankyou

[@m2ytech43]

Sir very useful video

[@MDataFinnovatics]

Thank you!

[@awadheshchaurasiya7739]

Sir thanks a lot. interactive teaching method.

[@MDataFinnovatics]

Thanks, Awadhesh for liking the video!

[@user-lu3np6us8r]

Amazing explanation. Wonderful 👍

[@MDataFinnovatics]

Thank you!

[@manmohansingh2194]

Thanks for your video on this topics

[@MDataFinnovatics]

Thanks, Manmohan, for watching our videos. My pleasure.!

[@Radhe.mahant2010]

Sumproduct Best video ever ❤

[@swapanbhattacharya4155]

Too Good. Thank you.

[@MDataFinnovatics]

Thank you Swapan!

[@sarfdhillon]

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.

[@kadarmumbaikar]

Dear sir as kindly add #learnexcelinhindi har formula Hindi use karna ..aapki Rich kafi badani chahiye ..A1 quality videos ...lots of love and respect ❤️

[@MDataFinnovatics]

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.

[@ranjeetverma774]

Amazing tutor

[@RohitKumar-cc7zi]

Owesom bro, you have a good way to teach, Keep it up ❤

[@MDataFinnovatics]

Thank you Rohit Kumar!

[@cutactions]

I don't subscribe normally but you deserve ❤

[@rameshchandragoyal4494]

Perfect & nice teaching

[@MDataFinnovatics]

Thank you, Ramesh ji, for watching our videos!

[@rajesh_pote]

Well explained ❤️

[@M.HanifK]

Thanks bro ab ja k formula samaj main aya.

[@MDataFinnovatics]

You're welcome, Hanif Khan!

[@AlAmin-ne7sv]

excellent

[@MDataFinnovatics]

Thanks Al Amin. Keep learning and sharing

[@vittalgarole]

Thank you

[@MDataFinnovatics]

You're welcome

[@ubaidillahmuhammad20]

Like it. Thanks

[@MDataFinnovatics]

Thank you Ubaidillah Muhammad!

[@cutactions]

Wah,kamal

[@pulakgoswami6697]

Thanks

[@latesttechnicabdullah8672]

Thanks sir

[@MDataFinnovatics]

Your welcome Sir!

[@galahadxd]

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 ?

[@tippusabeel62]

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.

[@MDataFinnovatics]

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!!

[@dkboss5439]

Great sir🥰

[@MDataFinnovatics]

Thank you!

[@mirzawaqar857]

What an example

[@pear-cy6qp]

amaizing

[@MDataFinnovatics]

Thank you!

[@manmohansingh2194]

Super

[@brijeshshah574]

Mene is tarah se use kabhi nahi kiya tha pehle sum product ko

[@MDataFinnovatics]

👍

[@sarfdhillon]

I mostly use Google Sheets, do you have videos on that too? I am a heavy QUERY and INDEX/MATCH inquiry person.

[@m2ytech43]

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.

[@MDataFinnovatics]

The wildcards (*) can't be used in SUMPRODUCT formula. So, the above problem can be solved only by Sumifs formula.

[@mdmahibulislam8691]

❤❤❤❤❤❤❤❤❤❤❤Amagine

[@shyamallrounder]

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??

[@rajatkubade3235]

Please share example for conditions in column and row at same time

[@MDataFinnovatics]

Okay Rajat, we will try to create the similar example.

[@adeelahmedsiddiqui4381]

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

[@MDataFinnovatics]

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.

[@dipalishah4560]

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

[@MDataFinnovatics]

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.

[@aaaannnnuuuu0000]

we could have used "*" between the Array selected to get the desired result, Isn't it??

[@SanjaySingh-su4rn]

Sir formula big size mein dikhaye

[@MDataFinnovatics]

Okay Sanjay Ji, we will take care of it.

[@dkboss5439]

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

[@MDataFinnovatics]

Sumif ke formula ke through ho jayega but you need to use SUM and SUMIF formula together with { } brackets.

[@swayampak-swadgharcha1291]

Can we use if contains text in sumproduct formula

[@MDataFinnovatics]

Swayampak, you can try that and see the results!

[@dastaan_e_parinda6090]

Sir Can u please share the sheet for practice. Please

[@adarshrao3775]

Sir, sheet 1 ke 4th question me double negative kyu nahi use kie

[@user-zr5xc5xk1j]

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?)

[@AlimKhan-bl5sh]

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

[@AlimKhan-bl5sh]

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..

[@rushikesh77999]

Sumproduct((categary=c)*(location=UP))

[@malayadhikary5578]

Home work ka ans 1 hoga?? Koi bataye

[@kunalsoni4499]

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))

[@sumitchaudhari5815]

when you used AND (*) you did not use --. Why?

[@dkquiz1707]

15 min 14 sec double negative kyon nhi use kia gaya

[@MDataFinnovatics]

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.

[@upendra35]

Great Bro❤

[@MDataFinnovatics]

Thanks US..