Mastering Excel's SUMPRODUCT Formula vs others-COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS

Mastering Excel's SUMPRODUCT Formula vs others-COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS
1.SUMPRODUCT vs SUM and SUMIF
2.SUMPRODUCT vs COUNT and COUNTA
3.SUMPRODUCT vs COUNTIFS and SUMIFS
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#sumproduct #excelsumproductformula#Innozant #exceltutorial

[@dipak5651]

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❤

[@Innozant]

Thanks.Really means a lot to me

[@rashidabbasi679]

bahut bahut dhanyvad sir, mai sabhi ko suggest karta hu aapki vedio

[@Innozant]

Thanks Rashid 👍❤️

[@dsbohra]

Not just this one, every video you have made in the past as well, is really informative. Keep up the good work.

[@Innozant]

Thanks dear.Really means a lot to me

[@RAEES_Kaushar]

Apka to samjhane ka Jo tarika hai bilkul jawab nahi hai ❤❤❤❤❤

[@Innozant]

Thanks

[@rahul5d138]

You are Good teacher sir

[@RahulRoy-po9ct]

🙏 PRANAM SIR 🙏

[@hemendrakumarvarshney8825]

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

[@Innozant]

Thanks for your valuable appreciation.. Really means a lot to me.

[@Knu_804]

बहुत बढ़िया सरजी मजबूत हो रहा हूँ मैं सम प्रोडक्ट में ।

[@Innozant]

Good 👍

[@pramodbhavsar4488]

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

[@Innozant]

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.🙏❤️🙂

[@rashidabbasi679]

thanks sir i learn with your vedio

[@g2sagar]

Thank you sir. Mujhe itna sab sumproduct ke baare Mai nHi pta tha. Ab pta chl gya Sir. Thank you Sir

[@Innozant]

Array and Sumproduct ka video series dekhiye complete playlist .bht advantage hain uske

[@gauravbhatia7987]

Good sir je sum product mere abb bohat kam ayega thnq sir

[@Innozant]

Ok.thats Good.

[@Ashutosh1986]

This is the best video ever on sum product. Thanks a lot GURU,,,🙂

[@Innozant]

Thanks dear..Happy Learning

[@jatinsharma5024]

@@Innozant sir why you are using Coarse( 2 minus symbols) When you are already using * symbol between two arrays

[@harivanshgautam3424]

Very informative video Sir ji. You always enhance the capacity of thinking regarding Excel by your videos 🙏

[@Innozant]

Thanks Harivansh Gautam ji for such a valuable feedback,Will always try to make awesome videos.🙏❤️

[@vijaykumartuppe6317]

Aa! Aa! Ha! Mind blowing! Very interesting!!!!

[@Innozant]

Thanks Vijay Kumar Ji❤️

[@mdriyaj5908]

Nice sir ab samajh Aaya only one sumproduct used .❤️❤️

[@Innozant]

Thanks Md Riyaj❤️

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

[@rjraviraftarup7553]

Bahut badhiya sir

[@Innozant]

Thanks Ravi..🙏❤️

[@sureshkunnil]

thanks, great help for me today

[@xpertgaming5808]

best channel, very clear and concise

[@Innozant]

Thanks dear❤️🙏

[@hemantgusain1260]

Thanks you sir, through this we learn real use of sumproduct.

[@Innozant]

Thanks Hemant Ji..🙏❤️🙂Gn

[@msexcelgooglesheet374]

Awesome Video Sir ji. I love your efforts and consistency 💖🙏....

[@Innozant]

Thnks,m trying my best to deliver awesome content 🙏❤️🙂

[@pankajmathur9]

Tnk u sir for sharing the knowledge for free.... literally tnk u so very much 🤗 May god bless u😇

[@Innozant]

Thanks Pankaj ji God bless you.Happy learning

[@ishaa31]

sir. i am thankful to get a teacher like you. you make everything so simple,

[@Innozant]

Thanks Isha .Hope you are fine and Doing well in your life . Wishing you wonderful career ahead..God bles you❤️❤️

[@Suraj-to6gb]

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

[@Innozant]

Thanks Suraj ...

[@munendrarathore01]

Maje hi aa gaye yaar

[@Innozant]

Thanks

[@ismailafridi7028]

Sir kindly upload more about array method and upto basic

[@sandeepsingh0512]

Thank you so much for this video, it is really very helpful. 😊

[@kamalrao1295]

Awesome Sir

[@yogeshahire1823]

Nice Sir, A way to simply understand👍

[@Innozant]

Thanks Yogesh Ji🙏❤️🙂

[@soumensaha4426]

Awesome explanation. Many thanks.

[@Innozant]

Thanks dear ❤️

[@muhammadsaqlain5162]

Q k man apka bohot bara fan hon i love you sir very much.

[@Innozant]

Thanks dear ❤️😌

[@muhammadsaqlain5162]

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

[@muhammadsaqlain5162]

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

[@muhammadsaqlain5162]

@@Innozant Ap jo basic cheez batatay hai bohot amazing hoti hai, i proud of you sir.

[@REX-vo9yz]

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

[@NirajKumar-ie9xc]

Thanks Sir

[@Innozant]

❤️❤️

[@chandrashekharmishra9521]

Lots of thanks

[@meditationmusic6482]

Sir ji very nice 🤩

[@Innozant]

Thanks Dear Sanoj

[@elyasahmad1687]

Very nice

[@DurgeshYadavGamerz]

Thanks a lot. Really u r the best teacher in excel. I want to learn about VBA pls help me

[@Innozant]

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

[@naeemahmedpirzada9255]

Great great sir

[@Innozant]

Thanks dear ❤️🙏

[@rinturoy8014]

wonderful

[@jaiyadav1256]

Excellent

[@Innozant]

Thanks Jai

[@liteshchawla4843]

Nice videos sir,, really thankful to you...🙏🙏

[@Innozant]

Thanks Litesh Ji

[@mamalik1088]

Superior in Excel

[@Innozant]

Thanks Arshad

[@Radhe.mahant2010]

Love this video

[@1gopalakrishnarao]

Excellent. Very interesting. Thank you.

[@Innozant]

Thanks Sir..Hv a great weekend.🙏🙂

[@1gopalakrishnarao]

@@Innozant Thank you. I want your mailid to send the file for a solution. Please share

[@Innozant]

[e-mail]

[@Radhe.mahant2010]

Great video thx

[@Innozant]

Thanks Radhe❤️

[@maheshswami2064]

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.

[@Innozant]

Thanks Mahesh ji.Recommend you to start your learning journey step by step (videos in a sequence playlist link provided in video description)

[@sandeepkapoor2031]

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

[@mhaider6936]

Great!

[@chandrashekharmishra9521]

You have win my hurt ,realy

[@Innozant]

Thanks dear❤️👍

[@pradeepnegi7523]

Super sir

[@Innozant]

Thanks Negi Ji..Happy learning

[@Phadi_Vloger]

Sir sumproduct function using as a counta is not working properly

[@naeemkhan-tm9hx]

Superb

[@Innozant]

Thanks Naeem sahab🙏❤️

[@sandeepaswal8944]

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]

Thanks Sandeep,These lovely feedback is reason of my motivation dear.God bless you🙏❤️🙂

[@manojsingh-mf1lg]

Excellent sir 👌👌

[@Innozant]

Thanks Manoj ji

[@vijaysahal4556]

superb sir 👍🏻👍🏻👍🏻👍🏻

[@gumnaam6068]

COUNTA func counts all non-blank cells including errors as well. something SUMPRODUCT is not able to do. Pls add this detail as well.

[@deepakchougule29]

Hi sir Mere pass ek if condition hai use extend karana hai lekin samaj nahi aa raha hai kaise kare kya aap help karoge.

[@SanjayKumar-uw9kn]

Sir please make videos on TABLEAU. WISHING FOR A HEART

[@Innozant]

Taleau to abhi nhi..but soon we start Power series...Power query,power view,power map,power pivot and power BI🙏❤️

[@puransingh-sx2tk]

Ab pta chal Power of sumproduct plz subscribe kare like kare q k thoda motivation to sir ko bhi chahiye 🙏😊

[@Innozant]

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😀😍

[@msexcelgooglesheet374]

@@Innozant 😂🤣

[@sitaramkohli9549]

Sir *multiple sign use kre ya ,commma sumproduct(--(array1=criteria), sumrange

[@Innozant]

Jab range common na ho to multiply otherwise comma🙏❤️sumproduct advantage ka video teeno dekhiye..detail me smjhaya hua h

[@KuKu_247]

Sir, how to get rate by #sumproduct, from multiple criteria

[@rahulrakshe1988]

Nice

[@muhammadsaqlain5162]

Bus =sum(--( aagay ap jo kerna chahay ker saktay hai ye tricks bhi ap ne hi bataya tha.

[@Innozant]

👍❤️

[@kuberjadhav2492]

Array with Lookup Funtions ke videos banao sir,

[@Innozant]

Already hain dear..Videos array with lookup

[@surendraclia]

GREAT

[@Innozant]

🙏❤️

[@rhashmi1]

Excellent!

[@abhijitdey1819]

=SUM (1/COUNIIFS () IS UNIQUE COUNT KO MUJHE FILTER LAGANE KA BAAD BHI VISIBLE DATA PAR KAAM KARE KYA FORMULA HOGA PLEASE BATAYE

[@Funway20]

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

[@naeemahmedpirzada9255]

Sir sumproduct se great kese nikalta hy us ka bhi koi example bataen thanks

[@Innozant]

Grade?..ok..bana denge dear

[@gauravmunder8940]

Sir countif formula with filter data kse use kre

[@aqeelahmadengr3]

Interesting

[@Innozant]

Thanks Aqeel..Lo last me ek ques pucha hai Maine wo jarur attempt kijiye aur formula comment kariye mujhe

[@cartoonloversop6019]

सर अब आप VBA पर भी विडियो बनाये हमें इंतजार रहेगा

[@Innozant]

Haan jarur bnayenge dear

[@RAKESHKUMAR-qw9cn]

Sumproduct se sara hal kre jha par vlookup sumit counting etc sumproduct ki series start kre

[@Innozant]

Soon you may see more videos of sumproduct vs other function🙏❤️🙂

[@RAKESHKUMAR-qw9cn]

@@Innozant sir acha lga kuch nya seekhne ne ko mila. Aise vlookup, average etc . Solve by sumproduct formula.

[@nikhilsaini4957]

How to find the count of Unique Emp ID that is hold by individual EmpName? As "A" is having 2 unique Emp ID...

[@RohitKumar-cc7zi]

Great 👍👍

[@battlefansshorts8941]

Thank you sir ❤🌹😊

[@Innozant]

Thanks Ravi Ji❤🙏

[@usmantahir1193]

Hello are you there? Can i ask one question on this topic?

[@pradeepkrgupta4537]

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

[@asadyounas4405]

Sir sum product with countif is rank kasaia nekaloo gay

[@kishorpanara4191]

Sir ( sumproduct=(--( ) dubbel minus ka samaj me nahi agar video ho to link do jise dekh kar samaj jau sir baki sir awesome

[@Innozant]

Sumproduct ka to pura series hai dear..array and sumproduct playlist me jake dekhiye -- coerce ke upar pura ek video hai dear.

[@chandandasy2k10]

2d sum can do by sumif or sumifs

[@Innozant]

When we have set of conditions use sumifs

[@user-it6tx9eb7i]

Pls help ...need to count unique A/c based on TXn month and A/c activation month

[@arunendravishwakarma6698]

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.

[@Innozant]

when dimention is different then use * else --

[@secretkingstatus9343]

❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙❤️💙💕💚🖤💚💙❤️💕💙💙 sir ji

[@UmeshSingh-ye9mw]

How to count unique value of repeated value with multiple criteria? please.

[@Innozant]

Using countif find occurance of repeated content then count it

[@kunalsharma2661]

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

[@kishoreallampallu7485]

sir power query series shuru karo

[@Innozant]

Soon..Power pivot,Power Query,Power view,Power map then power BI complete course step by step we are going to introduce.

[@satishojha6240]

Sir quaers means if condition is true they convert to 1 and false convert to 0 in sumproduct Thanku sir good night.🙏🙏🙏

[@Innozant]

Yes Very Good.🙏❤️🙂M happy that you never miss to watch a single video..daily you learn then sleep..Good going.Gn

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@bishtlokesh1297]

First view sir nd amezing quotes for true false

[@Innozant]

🙏❤️Thanks Lokesh ..Yes more video uploading soon for Sumproduct vs other formula

[@bishtlokesh1297]

Taki hum bhi abse bs sumproduct use kre

[@bishtlokesh1297]

I want operation for sumproduct formula please I request u

[@pratikkarkera8211]

=SUMPRODUCT(--(EmpName"")) sir count a k liye yeh formula bhi thik hai na

[@Innozant]

Yes

[@sujankar100]

You taught good but all your video did not in proper series that is big issue to search past video ।kindly arrange all properly to help others to find 🙏

[@Innozant]

Dear Sujan,Innozant is one of the Organized channel for learning,Kindly check The Video Description for in sequence Playlist. Videos are categorised under their respective playlist.Watch Mis learning process video from playlist career guide to know how to learn in sequence

[@aashutoshpandey8753]

Please, Excel ki screen zoom kare.

[@prakashsingh1867]

I have a question of sumproduct. Can u solve please

[@Innozant]

@innozantofficial telegram id.🙏❤️

[@prakashsingh1867]

@@Innozant I don't have tellgram id

[@indranilsarkar4046]

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 !

[@Innozant]

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

[@ManishSharma-ok7rt]

Sir aapne excel maati institute se sikha hai kya..

[@Innozant]

NO Sharma Ji,Course to maine kahin se nhi kiya hai.Seekhane ka kaam hai mera aur Khudse apni skills enhance karne ka.🙏❤️

[@ishutiwari5567]

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?

[@Innozant]

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

[@ishutiwari5567]

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

[@Innozant]

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

[@ishutiwari5567]

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

[@Innozant]

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 👍

[@Dehati_Program]

How to sum between month

[@Innozant]

please find solution in Array & sumproduct Playlist vidieos