Mastering Excel's SUMPRODUCT Formula

Introducing Excel's one of the most versatile function "SUMPRODUCT function" is to do a sum of multiplications.The good thing about this function is that this i an array function but there is no need to use Ctrl+Shift+Enter to execute this,It works as standard function.
It can act as a conditional SUMIFS,COUNTIFS function or work as a lookup function as INDEX and MATCH does.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-TextAdvanced2.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#sumproduct #sumproductfunction #innozant #excelsumproduct #exceltricks

[@ashubedi4078]

I must say you have a world class knowledge on excel and especially you have gained a mastery on sumproduct function

[@Innozant]

Thanks dear for your valuable appreciation.Happy learning

[@adeshmishra5045]

@@Innozant hi sir way of your teaching is awesome every point goes into detail for making us understand thanks for giving us precious time in your life

[@Altaf_Alam]

@@Innozant sir aapko self earning ka koi source pata hai online mein jisse hum study ke saath saath kuch earn kar sake jo risk free ho 🙂

[@yogeshrao5924]

आपकी मेहनत के लिए 100 like sir जी आपने बहुत ज्यादा मेहनत की है इस वीडियो को बनाने मे

[@Innozant]

Thanks ..keep learning

[@DEEPAK_Dipa]

Sum product function ko itni acchi tarike se Samjhane ke liye aapko 💯 topo ki Salami Di Jaati Hai🎉🎉❤❤😊😊😊

[@pavanprabhu3427]

No words sir the way you explained the SUMPRODUCT. I have never understood this function till today but you made the step by step explaination so easy to understand. You are the best of best! Thank you

[@anuanilbisht1983]

Sir, Kya baat mene bahut se videos dekhi but aap ka tarika Jo batane ka hai wo bahut hi badhiya hai. Aap pura operation karke iski details batate ho baal k barabar. I really hats off to you. 😘😘😘😘😘🙏🙏🙏🙏

[@Innozant]

Thanks Anil Ji..happy Learning ❤️👍

[@atherbeg2177]

SIR, I'M FROM PAKISTAN & LOVE YOU SIR, LOVED THIS TUTORIAL. THANK YOUSO MUCH SIR

[@Innozant]

Thanks Ather

[@javedali230]

thanku so much sir aap itni achhi achhi or knowledge full vedio banate ho....aap bahut achhe se smjhate ho... or sab se alag or advance tarike se aap sikhate ho...

[@Innozant]

Thanks Sayed itne valuable feedback ke liye .God bless You... Seekhiye aur life me aage badhiye

[@vasimuddinsheikh3766]

Sir, Nobody can imagine how much effort you might have put to make this tutorial. That's all I'll say "सुपर से भी ऊपर " 😃

[@Innozant]

Thanks Sheikh Sahab for such a valuable appreciation..Really means a lot to me

[@sandeepaswal8944]

Sir this is a great video I haven't seen before this kind of video on KZbin.You done a great many of people learn lots of thing just because of you. you are a good teacher Sir.

[@Innozant]

Thanks Sandeep ji,Hope you learn and adds some value in your life every day

[@anilrajput6497]

Aapke explain krne ka tarikaa bahut behtareen hai sir. Thenkeew so much.

[@Innozant]

Thanks Anil Ji..God bless you dear❤️

[@rajgautam5282]

Sir salute to you. Such a mind blowing explanation. Fan of your's teaching method.

[@Innozant]

Thanks Raj for your lovely appreciation.

[@iamsainipawan]

🙏 sir hamesha ki taraha is Baar bhi aapka concept is mind blowing Kitna effort karte ho aap humein sikhane Ka taki humara concept ekdum clear ho Jaye 🙏👍

[@Innozant]

Thanks Pawan Ji👍❤️

[@Altaf_Alam]

Sir aapka explanation super se bhi upar rehta hai 🤗❤️🙏

[@SunnySingh-mp4eq]

Wow.. I think this is the best video to understand the base of sumproduct. Request you to please make video series on match, index, indirect, offset and pivot table from beginners to advance level. Thank you for this amazing video.

[@Innozant]

Thanks Sunny ,Lookuo series Beginner to advanced level video in sequence alreadu uploading jn seprate playlis,You may learn from there step by step complete tutorial are there

[@dineshparmar2488]

You have very deep and amazing knowledge of Excel, I really thankful for sharing very powerful content with us, hats off to you.

[@Innozant]

Thanks Dinesh Ji..Happy Learning ♥️

[@Knu_804]

बहुत ही अच्छे से हर चीज़ क्लीयर हो गई सरजी , आप तो गजब हो सरजी ।

[@Innozant]

Thanks

[@badalsingh2050]

Super understanding I have been use many sumproduct but never understand this formula functioning like this thank you sirr!!

[@Innozant]

Thanks Badal ..Really mean a lot to me.Happy learning🙏❤

[@Ashutosh1986]

this is best video i have ever seen...awesome...thanks a lot for teaching in such a easy way

[@Innozant]

Thanks dear..Gid bless you..Happy learning

[@stitch-fitfashionlifestyle8148]

Extremly amazing and simple to understand your tutorials. Thank you very much.

[@Innozant]

Thanks Dear.. Happy Learning.🙏❤️

[@jaindigitalinvitations]

It is amazing !!!Explained the concept of sumproduct with simplicity

[@RAKESHKUMAR-ke6sx]

Mazaa aa gya Sir, Thank U sooo Much Aaj ka din bn gya, kuch New sikh gye

[@Innozant]

Thanks Rajesh ji

[@pravinwani4031]

Sir, You are the Best Teacher👍... I learn lots of from you Sir. Thanks.

[@Innozant]

Thanks ❤️

[@ajinkyagaikwad6307]

aapke sum product se wfm ki job mil gayi sir.love u sirji❤️

[@Innozant]

Great ..Keep Growing

[@RaviKumar-pr2by]

Excellent I don't know earlier "--" Double Negative but the way you taught its really easy Thanks U.

[@Innozant]

Thanks Ravi

[@spdas5942]

❤you sir, the best explainer of excel functions. Thanks enough.

[@Innozant]

Thanks Mr.Das

[@ajinkyashinde1778]

Extremly amazing and simple to understand your tutorials. Thanks 💕💕💕💕💕

[@Innozant]

Thanks Ajinkya for such a wonderful feedback.Hope you are learning and enhance your skills .

[@prakashchaudhari8444]

Simply great sir. Hats off to your way of explaining.

[@Innozant]

Thanks Prakash Ji ❤️

[@classs7474]

Sir,you are a genius personal,thanks alot to make us understand each and every thing

[@Innozant]

Thanks dear. Keep exploring

[@shaileshkumar-qf6bd]

Dandwat pranaam guru ji I m so happy and topic cleared 🙏🙏

[@Innozant]

Thanks dear

[@dsraghav2882]

Amazing Sir Such m av samajh m aya h itna to coaching m bhi nahi batate . If anyone agree with me plz hit like I watch everyday your videos. Awesome Sir thank you so much

[@Innozant]

Thanks Dharmendra Ji❤️🙏Yadi coaching me sabhi teacher apna 💯 dein aur business na samjhke ye samjhen ki student ke career Ka sawal h na ki paise sirf kamane Ka to hum that's hua kyu feel krenge .but aisa hota nhi h . Thanks 🙏 for giving love and support 🙏♥️

[@bazzelrahman5879]

Bhot easily explain Kiya apne sir. THANKYOU

[@Vinmam1231]

Love you sir from Bangalore... Awesome tutorial

[@Innozant]

Thanks Vinayaka

[@shafeeq1066]

Thank you sir for your teaching us. Keep it up. Have a progress

[@awanishanurag1763]

Need full dedicated content on Volatile and Non Volatile Functions!!

[@sachinbaluni7480]

Best explanation sirji😊

[@hemantgusain1260]

You are amazing, you explain everything very well.

[@Innozant]

Thanks Hemant Ji,Hope tou like the concept and example

[@amaninderkaur4145]

Great !! You are a saviour!!🙏

[@Innozant]

Omg...M speechless Amaninder .. Really Means a lot to me..Aapne the happy aur emotional ek Saath Kar Diya mujhe... Thanks a lot for this much love and support.❤️❤️🙏🙏 hope you like the teaching methodology and start lea step by step.👍🙏

[@samarahmad4784]

Laajawab pdhate hai sir aap

[@bairaGi_AkB]

Explain very good sir, many many thanks 👍

[@sunil101kumar]

Love this example. Love you once again...

[@Innozant]

Thanks Sunil Ji..Love you dear for this Lovely appreciation .

[@indiansingh837]

Best topic teaches best❤️ thanx alot big boss 🙏🏻

[@Innozant]

Thanks Singh Sahab .❤️🙂👍

[@Muhammad_Shahnawaz]

Excellent Honorable... Love from Pakistan

[@Innozant]

Thanks dear.Keep learning

[@gauravbhatia7987]

Good sir sumproduct ki video repeat dekhni padegi ashe se sikhna padega

[@Innozant]

Haan sumproduct dubara recap lijiye..it's very important function dear.❤️🙏👍

[@N_H12345]

Bahut khubsurat answer sir

[@shahzadsiddiqui5117]

one word......Superb

[@maddy2613]

thank you sir.... finely explained.

[@Innozant]

Thanks Rohit

[@pawanverma7220]

-- minus ka doubt clear ho gaya Iss bar ❤️❤️❤️

[@Innozant]

ok..thats good

[@asmrindia]

Superb Sir

[@Innozant]

Thanks dear

[@Techwithmzh]

Lots of respect from Pakistan

[@Innozant]

Thanks Zeeshan

[@meditationmusic6482]

So nice 🤩 sir ji

[@Innozant]

Thanks Sanoj ji

[@samarahmad4784]

Best of best hai sir aap

[@karanyadav1813]

Really best experience here.

[@worldwidefact1]

Sir i love your explanation ❤️❤️

[@Innozant]

Good Morning..Thanks dear..hope these videos are helpful for you❤️

[@RohitKumar-uy7cx]

Nice 😊 sir ji very well explained

[@Innozant]

Thanks Rohit🙏❤️Happy Learning

[@msexcelgooglesheet374]

Now I got the exact use of - - double negative sign

[@Innozant]

Thanks dear🙏❤️

[@rajeevgosavi4514]

Nicely explained in simple and effective manner. Looking forward to more videos on sumproduct. Thanks

[@Innozant]

Thanks Rajeev Ji..Sure will make more videos for the same

[@jaishrisaxena1083]

Amazing , wonderful explanation!!!

[@Innozant]

Thanks Jaishri for such a valuable comment

[@dktyagi80]

Extremely amazing

[@Innozant]

Thanks Tyagi ji❤️

[@karankapoor200]

wonderful video sir👌🏻👌🏻

[@Innozant]

Thanks Karan

[@mohdjakir6719]

You are a such amazing sir

[@vijayhaldar2512]

Bahut hi badiya

[@Innozant]

Thanks

[@wrongturnlima007]

Incredible sir 🙏

[@DEEPAK_Dipa]

Its compulsory for all time Double negative for getting output or it is possible that we put Double negative in all questions with more than two conditions

[@Innozant]

It's not mandatory

[@sumanjoshi990]

Excellent

[@shrikantbadge3978]

Excel के द्रोणाचार्य दिलीप सर

[@Innozant]

🙂

[@rahulrakshe1988]

nice explain sir ji

[@abidnawaz8527]

Sir. How can I use sum product function when I have 2 arrays one range I need to divide by 40 and multiplying with another range and one range only multiplying with another range ?

[@tanveeraslam3694]

Please share a video on assign macro button work in protect sheet. And hidden formulas

[@Innozant]

Ok..Macro series me layenge ya ye to alag se BHI add Kar sakte h video

[@AnupKumar-oe2jb]

Very nice Sir

[@Innozant]

Thanks Anup

[@bhoopendraraghav9781]

Amazing video

[@Innozant]

Thanks Bhoopendra Ji,Hope you learn and enhance your skills everyday

[@josephlobo3703]

best coach

[@Innozant]

Thanks Joseph❤️

[@nileshchavan742]

Congratulations 1k viwes 👍

[@Innozant]

Acha means logon ko sumproduct pasand aa raha hai..aur uska use bhi kar pa rahe hain.Good❤️🙏

[@meragaonconnection7382]

Ultimate....

[@Innozant]

Thanks Santosh Ji

[@pramodbhatt6906]

Sir have a doubt in sumproduct pl help when we have to apply * and when we have to apply , (Comma)

[@ARHAM559]

Sir how can I apply SUMPRODUCT for multiple table or multiple columns with spaces

[@SAJJADAHMAD-uy3hu]

If we don't give double negative then it shows zero. It means by default it convert false to zero i.e we don't give doble negative. Right? Correct me if wrong.

[@pareshparikh7944]

Superb

[@abidnawaz8527]

Sir if I have multiple sum range with multiple criteria how that would be done by SUM PRODUCT ?

[@abidnawaz8527]

Sir I have asked 2 questions but there's no reply from you I am also you student and subscriber

[@GDDIMRI-gb7vi]

Bhayi Kya- ko + mai bhi de skte hai Eska funda kya hai

[@Sarita_Classes]

Sir I have douts abouts quotes ... please explain easily

[@Innozant]

Kindly ask your query

[@Sarita_Classes]

@@Innozant Sir Why we use "- -" in sumproduct.. explain in details..with easy examples

[@horrorlovestories]

Sir mughe sum product use karna hai filter function ki jagah aur count karna hai outstanding task without strike through effect toh woh kaise karna hai?

[@AbhishekKumar-nb4et]

Sir mera ek Dout hai . Ki ye double parentheses kab use karte hai aur kab single use karte hai in sumproduct ? Please explain in short🙏

[@Innozant]

Complete series dekhen sumproduct ke apke doubt clear hote jayenge

[@atherbeg2177]

The formula works fine, until I replace the range with a dynamic named range I created with Offset formula, after using that it's giving me sometimes N/A sometimes Value error, please help

[@bhupendramishra7991]

Great!

[@PRAVEENKUMAR-cy6li]

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

[@paps7787]

excel main mere pass ek column main A1=42(01) B1=13 C1=10(05) value hai agar mujhe bracket vaali value chod ke baki value ka total karana hai toh kya formula hoga

[@devenkumark]

Amazing explanation , but why don't you start VBA series from scratch.

[@Innozant]

Will start VBA series after Power BI

[@devenkumark]

I am really appreciated you work and effort so I am looking forward you that will get new vba series soon

[@prabhatraj8384]

Sir, I use a ready-met formula in daily reporting but I can't understand this formula. =SUMPRODUCT(SUBTOTAL(3,OFFSET(M6:M10084,ROW(M6:M10084)-MIN(ROW(M6:M10084)),,1))*(M6:M10084="Yes"))

[@mayankbhatt1790]

Osm vedio but I didn't get the practice file in your folder plzz help me I needed this slide and practical file

[@Innozant]

Practice file is alredy there kindly download and start your practice

[@mayankbhatt1790]

Mere pass saari practice file mil gyi hai but ye Vali ni mil plzz if uhh are able to give direct link of only particular this practical then give me I'm ur gratitude plz help me 🙏🙏🤗😊

[@Innozant]

search krna hoga..will add direct link there

[@mayankbhatt1790]

Search Kiya meine but mujhe nii Mila isliye bola meine kyunki pura download kr liya hai

[@mayankbhatt1790]

Chaliya koi baat nii thank you for precious time 😊😊😊

[@mohdumarkhan7361]

Please help sir, I am facing this problem, ( Mere pass 3 column , 1st mein names repeat hain, 2nd mein criteria and 3rd mein mujhe count chaiye 3rd column me amount hai but mujhe sirf count chaiye please help sir)

[@jaidevbhoomiuttarakhand]

Answer not found to solve the last example .

[@Innozant]

Which one Mahesh Ji?

[@sowebakhtar251]

Vba. Full course video banaye sir

[@Innozant]

Power series ke baad whi layenge dear

[@sowebakhtar251]

@@Innozant thank you sir

[@karimansari4136]

Sir...i Have one Question. How To Split Date 12/11/2021 in Different column (ie. 1st column 12 2nd column 11 and 3rd column 21)

[@Innozant]

It's very easy using Excel formula or using Power query..kindly learn step by step course ..

[@karimansari4136]

@@Innozant send me video link can i prepare

[@Dehati_Program]

Sir sumproduct 4499 row tk hi work krta h isse jada rang agr range select krta hu to #Value! A jata h

[@Innozant]

Matlab??

[@Dehati_Program]

@@Innozant I mean mere pass ek sale dump h usme 10k row tk data h usme se muje multiple criteria ke sath kuch product ka sum chahiye, bt mera jb mai sumproduct lgata hu 1st row se 4499 row tk tb to results correct deta h, bt mera data 10 k row tk h agr hm 4499 se jada ek bhi row select krke formula lgata hu to work ni krta h error a jata h ye bala #value!

[@mazizulrehman11]

Thanks

[@UmeshSingh-ye9mw]

How to ignore blank cells if any in sumproduct?

[@Innozant]

You want to ignore blank cell using sumproduct ?or wht you want to say didn't get you Umesh ji,Kindly elaborate again.🙂

[@ajverma9740]

sum wala without negative k bhi ho jayega =sumproduct((array1="TX")*(arrey2)) then enter

[@ashishbhargava7250]

super

[@rish545]

mera to favourite subtotal hai wo sb kuchj krta h

[@Innozant]

👍

[@abhishekchadha5002]

Is video mai recently changed aaya hai 0.25 mai 😊

[@Innozant]

Kya changed aaya hai video me?