Mastering Excel's SUMPRODUCT Formula

Подписаться 151 тыс.

Просмотров 81 тыс.

50% 1

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

Опубликовано:

19 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 218

@ashubedi4078 2 года назад

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

@Innozant 2 года назад

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 🙂

@atherbeg2177 Год назад

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

@Innozant Год назад

Thanks Ather

@yogeshrao5924 10 месяцев назад

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

@Innozant 10 месяцев назад

Thanks ..keep learning

@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 ❤️👍

@vasimuddinsheikh3766 3 года назад

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

@Innozant 3 года назад

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

@sandeepaswal8944 4 года назад

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

@Innozant 4 года назад

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

@rajgautam5282 3 года назад

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

@Innozant 3 года назад

Thanks Raj for your lovely appreciation.

@bazzelrahman5879 19 дней назад

Bhot easily explain Kiya apne sir. THANKYOU

@ajinkyagaikwad6307 Год назад

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

@Innozant Год назад

Great ..Keep Growing

@javedali230 2 года назад

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 2 года назад

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

@Altaf_Alam Год назад

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

@RaviKumar-pr2by Месяц назад

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

@Innozant Месяц назад

Thanks Ravi

@SunnySingh-mp4eq 3 года назад

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 3 года назад

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

@Altaf_Alam 2 года назад

Thank so much sir ji ...bahot accha explanation kiye 🤗

@Innozant 2 года назад

Thanks Alam sahab

@dineshparmar2488 2 года назад

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

@Innozant 2 года назад

Thanks Dinesh Ji..Happy Learning ♥️

@stitch-fitfashionlifestyle8148 3 года назад

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

@Innozant 3 года назад

Thanks Dear.. Happy Learning.🙏❤️

@impawansaini08 3 года назад

🙏 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 3 года назад

Thanks Pawan Ji👍❤️

@RAKESHKUMAR-ke6sx Год назад

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

@Innozant Год назад

Thanks Rajesh ji

@badalsingh2050 3 года назад

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

@Innozant 3 года назад

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

@ajinkyashinde1778 4 года назад

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

@Innozant 4 года назад

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

@jaindigitalinvitations 2 года назад

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

@pravinwani4031 3 года назад

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

@Innozant 3 года назад

Thanks ❤️

@Knu_804 Год назад

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

@Innozant Год назад

Thanks

@anilrajput6497 2 года назад

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

@Innozant 2 года назад

Thanks Anil Ji..God bless you dear❤️

@Muhammad_Shahnawaz Год назад

Excellent Honorable... Love from Pakistan

@Innozant Год назад

Thanks dear.Keep learning

@dsraghav2882 3 года назад

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 3 года назад

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 🙏♥️

@shaileshkumar-qf6bd 2 года назад

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

@Innozant 2 года назад

Thanks dear

@Vinmam1231 2 года назад

Love you sir from Bangalore... Awesome tutorial

@Innozant 2 года назад

Thanks Vinayaka

@Techwithmzh Год назад

Lots of respect from Pakistan

@Innozant Год назад

Thanks Zeeshan

@Ashutosh1986 3 года назад

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

@Innozant 3 года назад

Thanks dear..Gid bless you..Happy learning

@shahzadsiddiqui5117 Год назад

one word......Superb

@classs7474 2 года назад

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

@Innozant 2 года назад

Thanks dear. Keep exploring

@samarahmad4784 8 месяцев назад

Laajawab pdhate hai sir aap

@prakashchaudhari8444 2 года назад

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

@Innozant 2 года назад

Thanks Prakash Ji ❤️

@spdas5942 Год назад

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

@Innozant Год назад

Thanks Mr.Das

@sachinbaluni7480 Год назад

Best explanation sirji😊

@karanyadav1813 Год назад

Really best experience here.

@N_H12345 2 года назад

Bahut khubsurat answer sir

@maddy2613 2 года назад

thank you sir.... finely explained.

@Innozant 2 года назад

Thanks Rohit

@awanishanurag1763 2 года назад

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

@samarahmad4784 8 месяцев назад

Best of best hai sir aap

@shafeeq1066 3 года назад

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

@sunil101kumar 3 года назад

Love this example. Love you once again...

@Innozant 3 года назад

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

@hemantgusain1260 4 года назад

You are amazing, you explain everything very well.

@Innozant 4 года назад

Thanks Hemant Ji,Hope tou like the concept and example

@amaninderkaur4145 3 года назад

Great !! You are a saviour!!🙏

@Innozant 3 года назад

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

@gauravbhatia7987 3 года назад

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

@Innozant 3 года назад

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

@Kingpotash Год назад

Explain very good sir, many many thanks 👍

@asmrindia 3 года назад

Superb Sir

@Innozant 3 года назад

Thanks dear

@indiansingh837 3 года назад

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

@Innozant 3 года назад

Thanks Singh Sahab .❤️🙂👍

@pawanverma7220 3 года назад

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

@Innozant 3 года назад

ok..thats good

@mohdjakir6719 2 года назад

You are a such amazing sir

@worldwidefact1 2 года назад

Sir i love your explanation ❤️❤️

@Innozant 2 года назад

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

@sumanjoshi990 2 года назад

Excellent

@jaishrisaxena1083 4 года назад

Amazing , wonderful explanation!!!

@Innozant 4 года назад

Thanks Jaishri for such a valuable comment

@vijayhaldar2512 2 года назад

Bahut hi badiya

@Innozant 2 года назад

Thanks

@rahulrakshe1988 Год назад

nice explain sir ji

@msexcelgooglesheet374 3 года назад

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

@Innozant 3 года назад

Thanks dear🙏❤️

@rajeevgosavi4514 3 года назад

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

@Innozant 3 года назад

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

@meditationmusic6482 3 года назад

So nice 🤩 sir ji

@Innozant 3 года назад

Thanks Sanoj ji

@shrikantbadge3978 Год назад

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

@Innozant Год назад

🙂

@abidnawaz8527 5 дней назад

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 ?

@dktyagi80 3 года назад

Extremely amazing

@Innozant 3 года назад

Thanks Tyagi ji❤️

@josephlobo3703 2 года назад

best coach

@Innozant 2 года назад

Thanks Joseph❤️

@conceptstory5972 3 года назад

very very very very very very very very very very very very very thankful sir ! ek request hain sir, kindly side screen pe up jo dikha rahain ho, wo kindly up "indication" use kare to bohot subidha hoga, like: pc cursor. Thank you sir, I want to more step ahead with you

@Innozant 3 года назад

Ok..dear..Noted aage se mark kar diya krenge important pounts ko

@mazizulrehman11 Месяц назад

Thanks

@meragaonconnection7382 3 года назад

Ultimate....

@Innozant 3 года назад

Thanks Santosh Ji

@bhupendramishra7991 2 года назад

Great!

@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

@ARHAM559 7 месяцев назад

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

@wrongturnlima007 3 года назад

Incredible sir 🙏

@RohitKumar-uy7cx 3 года назад

Nice 😊 sir ji very well explained

@Innozant 3 года назад

Thanks Rohit🙏❤️Happy Learning

@paps7787 6 месяцев назад

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

@SAJJADAHMAD-uy3hu 10 месяцев назад

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.

@tanveeraslam3694 3 года назад

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

@Innozant 3 года назад

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

@pramodbhatt6906 2 года назад

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

@ajverma9740 8 месяцев назад

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

@karankapoor200 4 года назад

wonderful video sir👌🏻👌🏻

@Innozant 4 года назад

Thanks Karan

@nandabhati3200 Год назад

Thnx Sir

@horrorlovestories 2 года назад

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?

@AnupKumar-oe2jb 4 года назад

Very nice Sir

@Innozant 4 года назад

Thanks Anup

@ashishbhargava7250 2 года назад

super

@pareshparikh7944 4 года назад

Superb

@nileshchavan742 3 года назад

Congratulations 1k viwes 👍

@Innozant 3 года назад

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

@bhoopendraraghav9781 4 года назад

Amazing video

@Innozant 4 года назад

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

@GDDIMRI-gb7vi Год назад

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

@mohdumarkhan7361 2 года назад

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)

@devenkumark 2 года назад

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

@Innozant 2 года назад

Will start VBA series after Power BI

@devenkumark 2 года назад

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

@UmeshSingh-ye9mw 3 года назад

How to ignore blank cells if any in sumproduct?

@Innozant 3 года назад

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

@prabhatraj8384 2 года назад

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

@abidnawaz8527 7 месяцев назад

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

@abidnawaz8527 5 дней назад

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

@PRAVEENKUMAR-cy6li 3 года назад

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

@manishsoni125 8 месяцев назад

Sir sumproduct excel ko hang karde raha hai

@jaidevbhoomiuttarakhand 2 года назад

Answer not found to solve the last example .

@Innozant 2 года назад

Which one Mahesh Ji?

@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

@AbhishekKumar-nb4et 2 года назад

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 2 года назад

Complete series dekhen sumproduct ke apke doubt clear hote jayenge

@Dehati_Program 2 года назад

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

@Innozant 2 года назад

Matlab??

@Dehati_Program 2 года назад

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