Excel Sumif Function | Sumifs formula in excel in hindi

Learn how sumif and sumifs function works with simple and amazing explanation.
In this tutorial, I teach you how to use sumif and sumifs formula in excel with example and explanation in simple way. We use this formula when we want to sum the vale based on one or more condition.
We will learn about the SumIF an SumIFS function in Excel
What is SUMIF function in Excel
Where we use SUMIF and SUMIFS function in Excel
How to use a SumIF and SUMIFS function in Excel
Excel Sumif and SUMIFS Function Example with explanation
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#sumiffunction #sumifs #Innozant #excelsumifs #exceltips #Exceltutorial

[@VikasSingh-em3ol]

Excellent technique of teaching Sir. I have some knowledge of Excel but I get some new and unique thing in all your video . I am watching your MIS video series sir. I want to learn VBA and Power Query in deep so I want to purchase your course . Please provide me VBA and Power Query course link . Thank you sir.

[@Innozant]

Thanks dear .. Advanced Excel and Power BI Course is available now but VBA course videos will take some time

[@VikasSingh-em3ol]

@@Innozant Ok sir thank you 😊

[@anshuk8972]

bahut achhe smjya apne concept clear ho hya sir thanku

[@shahzadsami5613]

Strange don't know why very less views for such a great information, Excellent Information

[@Innozant]

Thanks Sami Sahab...Really means a lot to me

[@devendergusain8974]

yes less view because this is knowledge based video agar entertainment purpose hoti to lakhs view hote .....

[@gauravbanerjee7891]

With all due respect brother... Not exactly strange because we don't want to move ahead. It's always tough na. Even we want to upgrade our techs (cell phones) but hate to upgrade ourselves 😂.

[@Innozant]

@@gauravbanerjee7891 Very true

[@rameejkhan2955]

I fully agree with your words..

[@maanuutreja2222]

I have seen so many video for excel function but the way of your teaching is fabulous thankyou

[@Innozant]

Thanks dear .keep learning

[@shahzadsiddiqui5117]

kitna asaani s samjhaya sir aapne.... mje bahut problem hoti thi iski range lene me.. ab asani s krdunga..!

[@Innozant]

Good 👍

[@rohitkundu1402]

Maja aagaya sir apki teachiung method se, kal raat se sikthe jaa raha hu alag functions, Thank you!

[@Innozant]

Good👍

[@shreekrishnamishra4046]

Kya baar hai sirji, itna mushkil calculation itne aasaani ke saath aur bade majedaar tarike se bataya hai, Hatss off to u sir

[@Innozant]

Thanks dear.Keep learning

[@theamark09]

Excellent sir, aap Bahut badhiya samjhate hain

[@AkankshaGupta-v9v]

Excellent technique of teaching Sir. I have some knowledge of Excel but I get some new and unique thing in all your video.Thanku so much sir

[@priyankanaik1427]

Sir, your teaching technics are just awesome, the way you explain in your every video is very helpful for understanding every concept. Thank you so much..!!!

[@funactiondramaemotionfitne4536]

Thank you very much for making this complex formula in such a simple manner. Your teaching style is very good and an understandable manner so that anyone can get through it

[@Innozant]

Thanks.keep learning

[@thegreatindia753]

Sir app bada hi mast samjaye h Koi coaching m b aisa ni padhata Mai to hamesha Kisi problem me apka hi video dekhta hu

[@Innozant]

Thanks dear..😊❤️

[@naseebzeehan7986]

Very detailed... Loved it. First time I felt like my confusion is clear. I enjoyed a lot. Thanks Sir.

[@Innozant]

Thanks dear

[@ZeeshanHaider-ft4fd]

Mujhy sumifs k formula ma bhot problem ho rhai the but ap ny bhot achy sy guide kiyya❤😊

[@AltamasGamer-i6o]

sir ho sakta ha logo ko appka video thoda long lagye but jis hesab se app explain bistartpurak karta ho sab samjh me aha gya #thanks

[@Innozant]

👍

[@wariskhan6170]

Bhut hi zabrdst explain kiya hai sir. I'm from pakistan

[@Innozant]

Thanks Waris❤️❤️

[@DeepakSain11]

What a superb teacher ❤❤❤❤....you live long sir❤

[@DeepakSain11]

I'm beginner what can I learn everything on here

[@DeepakSain11]

Bcoz first time I got detailed videos on your channel ....I was waiting for this to years

[@muhammadaqibishaq8056]

Dear, You solved my big issue by this video - I want to thank you

[@yogendraalve7327]

sir andaz sikhana ne ka lajavab hai god bless you jai hind

[@Innozant]

Thanks Yogendra Ji .GN

[@sonalikundu4981]

Thank u sir ,mere jo doubts the apne clear kr dia 🙏

[@Innozant]

Thanks dear

[@ravindrakasar3101]

Sir your are super teacher sir, I love your teaching style.

[@Innozant]

Thanks Ravinder

[@gauravbanerjee7891]

Happy Rakshabandhan sir. Happy learning

[@Innozant]

Happy Rakshabandhan dear❤️❤️

[@newtondanish]

Mashallah Ye teaching style mere primary school wale ki yaad dila di Shukriya sir

[@Innozant]

Thanks dear for your love and support ❤️

[@LovlyAmit]

Sir aapka explain karneka tarika awesome 😎 hai

[@Innozant]

Thanks ♥️

[@shilendrakumar5132]

Sir you are really amazing to make us understand nicely No comparison of you to way of teaching So simple to understable Keep making such valuable video Hats off to you n waiting for your next Amezing vedio I became fan of you since when I went through of your pivot operation table of teaching the so simply a to z of the same Good

[@Innozant]

Thanks Shilendra Ji...For your valuable appreciation..Happy learning ❤️❤️❤️

[@vaishnavipadwad1999]

THANKYOU SO MUCH SIR ! Really I don't get this topic at all in my lecture I was so scared as I have to submit my assignment on this topic immediately but you really made me clear. You are fantastic. Please keep going and continue to make videos like this for us.

[@Innozant]

Thanks dear hope these help

[@rasool7822]

Always happy learn from you ❤️thanks a lot sir

[@rehansaif7854]

Thank you so much. God bless you with all Health and Happiness. 🤗

[@sheikhsarfraz2520]

Sir your teaching technique is superb

[@Innozant]

Keep learning.👍

[@pushpak5939]

Dhanyawaad sir , sumif and sumifs sikhane ke liya.

[@Innozant]

Thanks Pushpak..step by step seekte rhiye

[@akashchoudhary0178]

Thank you sir, you help us to learn sumifs formula by this video

[@Innozant]

Keep learning

[@SanjayGupta-lr6xs]

Good explanation. Perfect speed

[@hemendrakumarvarshney8825]

Sir, so well explained. I couldn't understand this earlier using this function but this session has clarified the concept. Thank you so much. God bless you with all Health and Happiness. 🙏

[@Innozant]

Thanks dear

[@rajpatel4596]

Good explain sir 👌👌👌👌

[@vinay7694]

Wah dost Kitana acha method samjha rahy aappp😊

[@Innozant]

Thanks..Keep Learning

[@youtubevilla7805]

Bhtt pyaara sikhate ho aap sir 💯💯

[@Innozant]

Thanks dear❤️Happy learning dear

[@uniquemobiletipstricks7714]

आप बहुत अच्छा काम कर रहे हो

[@Innozant]

Thanks

[@UmarKhan-uc4ch]

Awesome, great methods of teaching, I've ever experienced. Keep it up

[@Innozant]

Thanks Umar..Keep learning ❤️

[@vanshikachandak2736]

very well explained sir. Thank you

[@annappa4991]

Thanks bro, I like your teaching, mind blowing

[@Innozant]

Thanks dear

[@rinabharti1064]

Bahut achha smjhate h sir aap yese thanks

[@Innozant]

Thanks Rina..Keep Learning ..❤️

[@sohailahmed1483]

The way you teach its 💯👍 Love from Pakistan ❤️

[@Innozant]

Thanks dear

[@umeshvijay1814]

Bhut acha h sir samaj me aa gya

[@sheikhsarfraz2520]

Sir I have watched so many videos but kuch b understand na kar saka , lekin ap ka video sumif wala ik hi baar Mai samaj aaya

[@Innozant]

Thanks dear

[@sheikhsarfraz2520]

@@Innozant can we chat on whatsapp or email bcoz I want to send u a page in which I am unable to sumif , I have done single in criteria , but now I want to learn double criteria sum

[@Innozant]

@@sheikhsarfraz2520 @innozantofficial telegram id

[@mithleshsharma5561]

Achha sikhne ko mil rha h sir

[@deepalkumar8097]

Sar Mera name Deepak he aap subse achha sikhate ho Maja a jatta he

[@Innozant]

Thanks dear

[@38950]

You are amazing need your assistance regarding a formula

[@wariskhan6170]

Bhut hi zabrdst video thi sir

[@Innozant]

Thanks ❤️

[@himanifartiyal5407]

You are awsome Sir, apart from the excel i wish to learn basics of Tableau, hope you come up with an video in future soon.

[@Innozant]

Yes Himani...Soon Tableau series

[@moazzamkhan3885]

you are the best sir... thank u

[@Innozant]

Thanks dear ❤️

[@govindsharma9121]

Sir you are genius.

[@azhadshamim3122]

Really great video 📹

[@AjayGupta12345.]

Great teacher

[@shashanktrivedi1526]

Dhanywad mhoday

[@ritikagupta5388]

Your videos are blessings for me sir

[@Innozant]

Thanks Ritika.. Really means a lot to me

[@somashreejana1006]

Excellent 👍

[@thegreatindia753]

God bless you

[@barunsahu6062]

Awesome Sir ❤

[@rajsub3884]

Nice presentation

[@hemchandpawar459]

Nice 👍 explain vedio

[@basantpachouli343]

Best line "Renga", "maharang"

[@user-hq5gr9hk1j]

Very well explained

[@rishisonirishissoni]

Hi Sir. You are requested to share more examples on sumif function. I want to practice more.

[@qaisarshahzad61]

Method is very good

[@chatwithsubhra1]

Amazing Sir ...

[@iqramanzoor1224]

Excellent.thanks

[@chandanarya1784]

BAHUT ACHHA HAI SIR

[@Innozant]

Thanks

[@subhashdhoke8439]

Sir, mai interview ko gaya tha, tab mujhe sum se related sawal pucha tha. Jisame unko kahna tha ki various name the unka sale diya gya tha, unka total sale dikhana tha, but data validation laga tha, aur data in rows tha like markshit hoti hai. I could not do it

[@KiritBhoot]

Dear Sir, i have been watching excel tricks videos and learning. I would like to know for Sumif/sumifs functoon. I am trying to sum of certai n crite area but the sum rangrs are in different raws so the formula does not give right sum. Eg : sum of B2:R2 and B20:R20 There are only 2 crite area "HP" and "ACT" Pl. guide to use formula Regards

[@yomipoint7253]

Thank you so much🙏 sir jii

[@MehediHasan-hk9mk]

Excellent

[@harismehmood5412]

Excellent...

[@dancecity5879]

I love to learn more in excel tricks and your teaching techniques are very good 👍it's make learning easier. 🙌

[@Innozant]

Thanks Dear... Practice on regular basis..all playlist assigment are there

[@Innozant]

Thanks dear .happy Learning

[@shivangirai3478]

Thanku so much guru Ji 🙏

[@Innozant]

Thanks Shivangi... Thanks for being part of Innozant Family..Start your learning journey from playlist Basic Excel onwards

[@dilipshedge8503]

Yes sir video pasand aaya ✔️

[@Innozant]

Thanks Dilip Ji♥️👍

[@vivekraghav6176]

Thanku sit

[@statusking6382]

Super sir👌💯👌👌

[@mistughosh637]

Sir, The way you teaching it's really great and very easy to understand and learn. But seems to be you are not uploading any video since year. Please upload more video. Thanks

[@Innozant]

Thanks..We are uploading video on regular basis.. Advanced excel course is completed now..kindly watch playlist in sequence

[@mistughosh637]

@@Innozant Many Thanks Sir. Will check.

[@mominenglishacademy4728]

Good job , you made it so easy to understand

[@Innozant]

👍

[@nitinshirke375]

Wow sir u r teaching is very brilliant

[@Innozant]

Thanks Nitin Ji, Happy Learning dear🙏❤️

[@jyotiarya3599]

U are to good sir

[@Innozant]

Thanks Jyoti..Keep Learning ♥️

[@majidmasud3969]

Excellent Information

[@Innozant]

Thanks Majid❤️

[@rituparnasengupta4242]

Amazing talented

[@PrayaashTheEndeavour]

Sir formula Freez ke liye kon sa Key use karte hain

[@AshwiniK-ds4sn]

beautiful explanation

[@Innozant]

Thanks Ashwani ji

[@mdsajjadhussain2653]

Thank u so much sir..

[@easylearningenglish5301]

Bahot achhe

[@Innozant]

Thanks ❤️

[@amandeepsinghbassi1600]

how to swap cell values of two adjacent column with if statement . pls make a video

[@huzaifakanakgeri7142]

Hats off …excellent

[@MithunSapui]

Thank you Sir

[@siddhantkumar2269]

Good teaching

[@Innozant]

Thanks Siddhant Ji❤️

[@luckydehury56]

Thank you such sir

[@AlimKhan-bl5sh]

Sir apne sumifs me jo name ko criteria range 1 liya tha na.... Fir apne criteria range 2 west liya tha.. Lekin mene just iska ulta kar diya.. Lekin answer dono ka same aaya tha.. Aeisa ku.. Kya hum age piche karke criteria le sakte hai kya?..

[@RA-rh5lb]

thank you Sir ji

[@VikramKumar-du2mw]

Brilliant Sir 👌👌👌👌👌👌

[@shadab917]

Hi Sir... I am very thankfull that I came across your channel... I have one querry.. if I want to use Sumif function and I have multiple table to look for the range... Ibtried to put range in a bracket like (AS12:AS20,AS32:AS40).. but it is showing Value error... can u plz help on it...

[@Innozant]

It won't support array

[@shadab917]

@@Innozant So...Sir Any Solution for that....

[@dhakafady774]

thanks a lot sir

[@sanjibnandi5641]

Fatafati.....

[@arshadpathan2758]

I love you sir 😊

[@deepakrahi]

Superb

[@dillipkumarbehera9060]

Wonderful