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.com/drive/folder...
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 😊

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

[@anshuk8972]

bahut achhe smjya apne concept clear ho hya sir thanku

[@user-vr8pu8wu8s]

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

[@muhammadaqibishaq8056]

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

[@ZeeshanHaider-ft4fd]

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

[@theamark09]

Excellent sir, aap Bahut badhiya samjhate hain

[@naseebzeehan7986]

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

[@Innozant]

Thanks dear

[@rasool7822]

Always happy learn from you ❤️thanks a lot sir

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

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

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

[@maanuutreja2222]

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

[@Innozant]

Thanks dear .keep learning

[@rehansaif7854]

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

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

[@sonalikundu4981]

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

[@Innozant]

Thanks dear

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

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

[@wariskhan6170]

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

[@Innozant]

Thanks Waris❤️❤️

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

[@umeshvijay1814]

Bhut acha h sir samaj me aa gya

[@SanjayGupta-lr6xs]

Good explanation. Perfect speed

[@vinay7694]

Wah dost Kitana acha method samjha rahy aappp😊

[@Innozant]

Thanks..Keep Learning

[@vanshikachandak2736]

very well explained sir. Thank you

[@pushpak5939]

Dhanyawaad sir , sumif and sumifs sikhane ke liya.

[@Innozant]

Thanks Pushpak..step by step seekte rhiye

[@VikramKumar-du2mw]

Brilliant Sir 👌👌👌👌👌👌

[@mithleshsharma5561]

Achha sikhne ko mil rha h sir

[@govindsharma9121]

Sir you are genius.

[@huzaifakanakgeri7142]

Hats off …excellent

[@akashchoudhary0178]

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

[@Innozant]

Keep learning

[@azhadshamim3122]

Really great video 📹

[@ravindrakasar3101]

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

[@Innozant]

Thanks Ravinder

[@wariskhan6170]

Bhut hi zabrdst video thi sir

[@Innozant]

Thanks ❤️

[@user-xn4ld6kq5w]

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]

👍

[@AjayGupta12345.]

Great teacher

[@sohailahmed1483]

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

[@Innozant]

Thanks dear

[@moazzamkhan3885]

you are the best sir... thank u

[@Innozant]

Thanks dear ❤️

[@somashreejana1006]

Excellent 👍

[@newtondanish]

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

[@Innozant]

Thanks dear for your love and support ❤️

[@UmarKhan-uc4ch]

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

[@Innozant]

Thanks Umar..Keep learning ❤️

[@yogendraalve7327]

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

[@Innozant]

Thanks Yogendra Ji .GN

[@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..😊❤️

[@LovlyAmit]

Sir aapka explain karneka tarika awesome 😎 hai

[@Innozant]

Thanks ♥️

[@iqramanzoor1224]

Excellent.thanks

[@hemchandpawar459]

Nice 👍 explain vedio

[@shashanktrivedi1526]

Dhanywad mhoday

[@rajsub3884]

Nice presentation

[@barunsahu6062]

Awesome Sir ❤

[@sheikhsarfraz2520]

Sir your teaching technique is superb

[@Innozant]

Keep learning.👍

[@annappa4991]

Thanks bro, I like your teaching, mind blowing

[@Innozant]

Thanks dear

[@mehakjan5217]

Awsome❤❤

[@udaychandrajha1726]

Amazing 😍👌👌😍

[@rinabharti1064]

Bahut achha smjhate h sir aap yese thanks

[@Innozant]

Thanks Rina..Keep Learning ..❤️

[@rituparnasengupta4242]

Amazing talented

[@mdsajjadhussain2653]

Thank u so much sir..

[@harismehmood5412]

Excellent...

[@thegreatindia753]

God bless you

[@SudhirKumar-bx3rk]

Sir, is there any way to use formula sumif with subtotal. So that desired result can be obtained while using filter by date to the targeted name.

[@user-hq5gr9hk1j]

Very well explained

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

[@chatwithsubhra1]

Amazing Sir ...

[@uniquemobiletipstricks7714]

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

[@Innozant]

Thanks

[@nitinshirke375]

Wow sir u r teaching is very brilliant

[@Innozant]

Thanks Nitin Ji, Happy Learning dear🙏❤️

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

[@mominenglishacademy4728]

Good job , you made it so easy to understand

[@Innozant]

👍

[@38950]

You are amazing
need your assistance regarding a formula

[@statusking6382]

Super sir👌💯👌👌

[@deepakrahi]

Superb

[@adityapatel4664]

Thank you sir.....

[@dilipshedge8503]

Yes sir video pasand aaya ✔️

[@Innozant]

Thanks Dilip Ji♥️👍

[@dillipkumarbehera9060]

Wonderful

[@youtubevilla7805]

Bhtt pyaara sikhate ho aap sir
💯💯

[@Innozant]

Thanks dear❤️Happy learning dear

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

[@sanjibnandi5641]

Fatafati.....

[@MehediHasan-hk9mk]

Excellent

[@ritikagupta5388]

Your videos are blessings for me sir

[@Innozant]

Thanks Ritika.. Really means a lot to me

[@ghulamsarwar4677]

Don't know why less views despite how simply he makes understand how to use if formula.

[@Innozant]

Thanks Gyula for such a valuable commment dear.
Really means a lot to me.God bless you..Happy learning

[@biswanathchatterjee9816]

freeze short cut kya use karte hai sir

[@rishisonirishissoni]

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

[@chandanarya1784]

BAHUT ACHHA HAI SIR

[@Innozant]

Thanks

[@MithunSapui]

Thank you Sir

[@yomipoint7253]

Thank you so much🙏 sir jii

[@qaisarshahzad61]

Method is very good

[@dhakafady774]

thanks a lot sir

[@deepalkumar8097]

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

[@Innozant]

Thanks dear

[@amandeepsinghbassi1600]

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

[@rahulkumarjain9432]

Nice👍

[@dhakafady774]

thanks a lot

[@majidmasud3969]

Excellent Information

[@Innozant]

Thanks Majid❤️

[@arshadpathan2758]

I love you sir 😊

[@luckydehury56]

Thank you such sir

[@gauravbanerjee7891]

Happy Rakshabandhan sir. Happy learning

[@Innozant]

Happy Rakshabandhan dear❤️❤️

[@devashishpanda6184]

Thank you

[@user-cb7bb7jq3o]

Nice video ❤❤

[@RA-rh5lb]

thank you Sir ji

[@9428077512]

HI Sir i want to use use sumifs function for indian finacial year , please guide me ?? thank you

[@nishachaudhary2527]

Great

[@AshwiniK-ds4sn]

beautiful explanation

[@Innozant]

Thanks Ashwani ji

[@Sandeepthakur-m4d]

Thanks sir