SUMIFS Formula in Excel in Hindi || SUMIF and SUMIFS Excel Functions | Deepak EduWorld

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024
  • sumifs formula in excel in hindi 2007/ 2010/ 2016/ 2013 - In this tutorial, I teach you how to use sumifs formula in excel. Sumif VS Sumifs. This formula comes into the advance excel category. we use this formula when we want to sum with more than one condition. Adds the total of cells in a range based on multiple criterion. SUMIFS formula in Excel sums cells in a range that match supplied criteria. Unlike the SUMIF function, SUMIFS function in excel can apply more than one set of criteria, with more than one range. The first range is the range to be summed. The criteria is supplied in pairs (range/criteria) and only the first pair is required. For each additional criteria, supply an additional range/criteria pair. in Sumifs formula in Excel Up to 127 range/criteria pairs are allowed.
    My New Channel : bit.ly/3qFrbl5
    Complete Microsoft Word Tutorial : • How To Do Office Work ...
    Complete Powerpoint Tutorial : • MS Power Point Tutoria...
    Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
    Vlookup Complete Tutorial : bit.ly/2K0C1Sb
    Excel All Formulas : • 40 most useful excel f...
    Office Work in Excel : • 🤓 How To Do Office Wor...
    Note that the order of arguments is different between the SUMIFS formula and SUMIF functions. Sum_range is the first argument in SUMIFS function in excel but the third argument in SUMIF.
    Learn How sumif and sumifs function work in excel 2007/2010/2013/2016
    how to use averageif formula in hindi
    • Advanced Excel Tutoria...
    how to use sumif formula in hindi
    • SUMIF formula in excel...
    how to use sumifs formula in hindi
    • SUMIFS Formula in Exce...
    how to use countif formula in hindi
    • COUNTIF formula in exc...
    HLOOKUP formula In Hindi
    • HLOOKUP in excel with ...
    VLOOKUP formula In Hindi
    • Vlookup in Excel With ...
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP ►
    • How To Make Passport S...
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld TH-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Tags:
    excel formulas, sumifs formula in hindi, sumif, sumifs formula, deepak eduworld, deepak nehra, excel tutorial, excel tips, excel user, computer tips, advanced excel tutorial in hindi, deepakeduworld

ความคิดเห็น • 701

  • @DeepakEduWorld
    @DeepakEduWorld  5 ปีที่แล้ว +50

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

    • @thakuryogesh9744
      @thakuryogesh9744 3 ปีที่แล้ว +4

      REALLY FANTASTIC

    • @starblack9419
      @starblack9419 3 ปีที่แล้ว +2

      Sir agar criteria range date ho tab ye Kam karega ya nahi

    • @miansam3420
      @miansam3420 3 ปีที่แล้ว +1

      bro may nay ak formula lagya ha jis may may nay if ka formula use kia ha exmpl
      agr colum a may 200 ha to 65 result ay agr 300 ha to 115 etc is tarha ki 6 condition lagai ha
      next ak new coulm may us ka sum karna ha to wo if formula wala colum chor kar baki sab ka sum kar dita ha is ka koi hal bata dain plz

    • @ghanshyamsharma4577
      @ghanshyamsharma4577 3 ปีที่แล้ว +1

      Rrr

    • @alameducationpoint2386
      @alameducationpoint2386 2 ปีที่แล้ว +1

      Jai hind

  • @sadiqahamad
    @sadiqahamad 3 ปีที่แล้ว +25

    Sir really hats off to you...I was struggling for almost 8 days in searching for the correct formula for application, you have solved my problem Thank you a lot...

  • @atikrashidshaikh2440
    @atikrashidshaikh2440 7 หลายเดือนก่อน

    Sir,
    Aapse maine vlookup sumif sumifs bahut hi ache se sikha aaj mai pura stock inward outward. Stock statement aapne sikhay hua formula se mentioned rakhta hu. Bhahut aasan Kam hua sir
    Great ho sir aap

  • @SSCOMPUTERCLASSES
    @SSCOMPUTERCLASSES 5 ปีที่แล้ว +1

    Sumifs formula ko Deepak ji aapne bahut asani se samjhaya hai.

  • @RashidKhan-zv1qm
    @RashidKhan-zv1qm 4 ปีที่แล้ว +1

    i m very impress ab har video me sheet bhi add kra diya kro jaise apki or video me hai hame solve krne me easy hoti h thank you

  • @thegreatindia753
    @thegreatindia753 2 ปีที่แล้ว +1

    Aapne bahut achha samjaya h sir jaise koi mujhe samne se hi tech kar raha ho ,🙏

  • @sunitaarora3030
    @sunitaarora3030 2 ปีที่แล้ว +1

    Wah kya baat h aap detailing bohot accha krte h. Thank you..

  • @makeupit3918
    @makeupit3918 ปีที่แล้ว

    Great so sweet your teaching method , main bhi exl start kar chuka hoon aapke videos as a starter dekhna chata hoon kaha se milenge aapke saare video

  • @umeshtippe290
    @umeshtippe290 4 ปีที่แล้ว

    Thank you deepak sir....apake video se pure sumif and sumifs dono formula ka use sama main aa gaya.......

  • @mdumairali4373
    @mdumairali4373 4 ปีที่แล้ว

    aap jaise teachers ki kami hai zindagi mai.

  • @AbhishekKumar-fx8tx
    @AbhishekKumar-fx8tx 2 ปีที่แล้ว +1

    Sir. Thank you 🙏🏻 itna accha samjhane ke liye

  • @ghumansaab2314
    @ghumansaab2314 4 ปีที่แล้ว +1

    Bahut ache se samjate ho bhai kmaal hai

  • @md.sakerurrahman5311
    @md.sakerurrahman5311 ปีที่แล้ว +1

    Bohot acha ta... May ab sik gaye..Thanks Dada

  • @abhijeetbhattacharya1548
    @abhijeetbhattacharya1548 2 ปีที่แล้ว +1

    your teaching strategy is very easy. anyone can understand. thank you very much

  • @savitagrover4677
    @savitagrover4677 10 หลายเดือนก่อน

    Itna badiya to koi teacher nah baa payega❤.really awesome.

  • @Ramkumar14178
    @Ramkumar14178 4 ปีที่แล้ว +1

    Maine kabhi koi computer class ya coaching nahin li.
    Lekin aapke viedeo dekh dekh ke bohot kuchh seekh gaya hoon

  • @vijayjadhav8255
    @vijayjadhav8255 2 ปีที่แล้ว

    Thanku you sir aapke VLOOKUP ke sare videos dekhe bahut helpful rahe hai or all videos bhi mast hai simple technique it's very easy to understand

  • @naughtynitika970
    @naughtynitika970 3 ปีที่แล้ว +1

    Deepak brother u r great and master in excel the way u are providing the excel information that is trimendose , i have been watching yor videos from last 2 months and now without taking any class now i can say to my self i m good in excel .just bcoz of your help bro thank u for the such all nice videos

  • @MdArman-bg9xr
    @MdArman-bg9xr ปีที่แล้ว +1

    Sir...really lajawab style for explain. Thank you

  • @AbhishekKumar-fx8tx
    @AbhishekKumar-fx8tx 2 ปีที่แล้ว

    Jo mujhe sir se samajh nahi aya wo apki video se aa gaya thanks سكرن

  • @raghavendrabs1647
    @raghavendrabs1647 ปีที่แล้ว +1

    Very nice... Explained it in very simple way of understanding..

  • @Unknown15697
    @Unknown15697 ปีที่แล้ว

    Love you sir aaj tk kise ne itna acha nhi samjaya❤❤❤😊😊

  • @Shailrajsingh-ks6hf
    @Shailrajsingh-ks6hf ปีที่แล้ว +2

    Thank you sir apne meri problem solve kardi 🙏🙏🙂

  • @shivenplayz6170
    @shivenplayz6170 2 ปีที่แล้ว +1

    app kubh his ahce sir ho shukriya apne meri itni madat ki aur apko abhay sir pata hai?wo bi bohot hi kadak sir hai

  • @fahimkhalid4523
    @fahimkhalid4523 4 ปีที่แล้ว

    Zabardast efforts Bhai kafi kuch seek ne ko mil tha hai apki Videos se Thanks

  • @tarulatabhatt4037
    @tarulatabhatt4037 4 ปีที่แล้ว +3

    I am new learner and I like your explanation very much sir. Thanks for this.

  • @laliteshkumar1031
    @laliteshkumar1031 6 ปีที่แล้ว +2

    बहुत अच्छा पढाते हैं मुझे काफ़ी अच्छा लगा . मुझे अब किसी और जगह पढने की कोई आवश्यकता नही. आप तो हैं ही.

  • @AnkitVerma-qj7ji
    @AnkitVerma-qj7ji 3 ปีที่แล้ว

    sir simifs bhot ache se smjh aaya. youare doing a veryy good job for needy prson. thank you. keep it up.respect.

  • @VIRATMASTI5874
    @VIRATMASTI5874 ปีที่แล้ว +1

    Really awesome.your way of understanding is quite easy & superb.

  • @amritathakur2036
    @amritathakur2036 2 ปีที่แล้ว

    I watched many videos but my confusion didn't solve but I watched your video finally my confusion solve...... thankyou sir give us valuable time TQ so much god bless you

  • @rajendrapatel5486
    @rajendrapatel5486 2 ปีที่แล้ว +1

    Easy way to learn... thanks sir

  • @utpaldas7200
    @utpaldas7200 5 ปีที่แล้ว +1

    Hello Sir ji, Aap bohot atse se explain karte hey. Ak bar me hi samaj me aa jata hey

  • @SukhdevSingh-vr4ej
    @SukhdevSingh-vr4ej 2 ปีที่แล้ว +2

    Thank you for easy way

  • @shineadhikari7408
    @shineadhikari7408 3 ปีที่แล้ว

    I just want to say god bless you sir

  • @anilkumarsingh4560
    @anilkumarsingh4560 6 ปีที่แล้ว +1

    Super Hit Video Sir Very Helpful video जय हिंद जय भारत जय श्री राम

  • @sapnaapnaapna
    @sapnaapnaapna 3 ปีที่แล้ว +1

    Nice trick.
    By use this.
    No need pivot many reports

  • @pahadikunal9488
    @pahadikunal9488 3 หลายเดือนก่อน +2

    awesome ❤

  • @jeewannailwal9659
    @jeewannailwal9659 5 ปีที่แล้ว +1

    Sir you are superb.. I daily follow your channel.. You r great person

  • @sudipsantra1127
    @sudipsantra1127 3 ปีที่แล้ว

    You r really a good teacher

  • @SKumar-ci7cc
    @SKumar-ci7cc 3 ปีที่แล้ว

    आपने बहुत अच्छे से बताया है धन्यवाद सतीश दिल्ली

  • @dakshkumar873
    @dakshkumar873 3 ปีที่แล้ว

    Thank you Sir.
    Aapne bahut acche se sikhaya.

  • @karanmali1512
    @karanmali1512 ปีที่แล้ว

    Very well explained sir....Thank You..!!🙏

  • @MrVikramgmr
    @MrVikramgmr 6 ปีที่แล้ว +1

    Very nice Deepak ji,, bahut bahut dhanybad aapka,, aapke dwara mene bahut kuch sikha hai,, Yani aaj main proud ke sath Kah sakta hun ki main excel me best hun,, aapke videos ka besabri se intezaar rahta hai, mera rutain ho gya hai jab tak aapki video na dekh leta, office se aane ke baad ek video jaroor dekhta hun or Subah office me Jakar experiment karta hun, again thanks Deepak ji,,

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว +1

      +Vikram Singh Choudhary . Thanka alot to u also.... I always try to give my best.... for all my followers... and I feel proud on myself when I read lovly comments of my followers... like u...

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว

      thanks

    • @MrVikramgmr
      @MrVikramgmr 6 ปีที่แล้ว

      Really Deepak ji,, aapke dwara ek ek word ko bahut hi gahrai se samjhana or overview, koi bhi hoga aasani se excel Sikh sakta hai,, aapki speech hi bahut Pyari hai,, main kuch bhul na jau isliye office me or staffs ke sath bhi share karta hun,, or aapke channel ko premot karta hun,,

  • @pesh-canttmarhabamktbilala8716
    @pesh-canttmarhabamktbilala8716 ปีที่แล้ว

    Thank You Deepak Sir i understood very clearly May Allah successful to you

  • @VikasSingh-sv9bp
    @VikasSingh-sv9bp ปีที่แล้ว +1

    Thank you for helping us sir❤

  • @sujaymenon2691
    @sujaymenon2691 ปีที่แล้ว

    Excellent deepakji thank you very much 😊

  • @kiransati3508
    @kiransati3508 ปีที่แล้ว

    🌺🌺You are the best🌺🌺 teacher🌺🌺 forever 🌺🌺

  • @HaiderAli-yz4wp
    @HaiderAli-yz4wp 2 ปีที่แล้ว +2

    Very Helpful Sir

  • @unknowndynamic9993
    @unknowndynamic9993 ปีที่แล้ว +3

    Thank you so much sir

  • @Virendrasagar1
    @Virendrasagar1 4 ปีที่แล้ว

    DEEPAK SIR AAP BAHUT ACHCHE SE SAMJHATE HO

  • @LiveIt-YouRLife
    @LiveIt-YouRLife ปีที่แล้ว +1

    JAzak Allah sir, absolutely awesome, Thank you sooo much. you solved all my consfusion.!God bless you!ameen

  • @shubhamsaini6743
    @shubhamsaini6743 3 ปีที่แล้ว +1

    Thank you so much bro for helping..

  • @shivkumarmishra7914
    @shivkumarmishra7914 ปีที่แล้ว +1

    Very helpful 😊🙏🏻

  • @muhammadadnan3900
    @muhammadadnan3900 2 ปีที่แล้ว +1

    ThnQ Bhai Deepak
    Lov frm 🇵🇰

  • @gbwquotes
    @gbwquotes 2 ปีที่แล้ว

    Boht boht shukria Deepak Bhaii. Allah aap ka bhala kare.

  • @ajayvishwanath9220
    @ajayvishwanath9220 2 ปีที่แล้ว +1

    fantastic explanation

  • @kuchbhijanoaurpahchaano3707
    @kuchbhijanoaurpahchaano3707 6 ปีที่แล้ว +1

    mujhe aapka sumif & sumifs ka function bahut accha laga.
    yadi aap iska date, ,= ko lagakr dikhate toh aur accha hota.

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว

      Ok i will publish video as soon as possible

  • @shankrukulkarni3234
    @shankrukulkarni3234 4 ปีที่แล้ว +1

    Thank you bro nice explanation

  • @awadheshkumartiwari4466
    @awadheshkumartiwari4466 ปีที่แล้ว +1

    Sir bahut achhr trike se bataya

  • @Itisme177
    @Itisme177 2 ปีที่แล้ว +1

    Thanks for ur clear explanation

  • @gajendrakarma9228
    @gajendrakarma9228 6 ปีที่แล้ว

    aapke video s bahut useful he

  • @mohammadimrangilani6222
    @mohammadimrangilani6222 5 ปีที่แล้ว +53

    is formula ke wjh se mera office me ijjat badh gya 2 paisa ke aadmi ho gye hum bhi office me😁😁😁😁🤪

    • @cultureandtourism7559
      @cultureandtourism7559 10 หลายเดือนก่อน +1

      😂

    • @rambirsharma3420
      @rambirsharma3420 8 หลายเดือนก่อน +1

      Bhai rhe fir bhi paise mein 1 rupee ke ho jate market mein rupee chalte hi paise nhi

    • @rambirsharma3420
      @rambirsharma3420 8 หลายเดือนก่อน +1

      Majak kr rha hu bura Mt manena

    • @mohammadimrangilani6222
      @mohammadimrangilani6222 8 หลายเดือนก่อน

      Yes bhai bht accha chiz hai excel ​@@rambirsharma3420

    • @Ak_computer_Gyan
      @Ak_computer_Gyan 7 หลายเดือนก่อน +2

      Amazing line bhai पढ़ते ही मन खुश हो गया sch me ❤ God bless you always

  • @raghavkalra1156
    @raghavkalra1156 2 ปีที่แล้ว +1

    Sir tussi great ho
    Very well explained
    Thanks 👍

  • @amitrelan3795
    @amitrelan3795 4 หลายเดือนก่อน +1

    Great Sir❤❤❤

  • @ShaziyakhanShaziya-gn8vm
    @ShaziyakhanShaziya-gn8vm 4 หลายเดือนก่อน

    Bhai bohat bohat thanks in formuly ki samaj muhje ohat aachi aarahi thanks for guideness .Mai online assignment work kr rahi hn usky leye Mai ny AP ky channel ko subscribe Kiya thanks for giving information AP ky Batana ka tarika boaht aacha hy

  • @kashiprashad.harharmahadev2933
    @kashiprashad.harharmahadev2933 10 หลายเดือนก่อน +1

    Very good study of math

  • @zaviyaarhussain3080
    @zaviyaarhussain3080 ปีที่แล้ว +1

    Amazing really helpful

  • @amitkumaragrawal4158
    @amitkumaragrawal4158 6 ปีที่แล้ว +6

    my confusion about sumifs got cleared after watching this video

  • @PushpaKumari-yp1mo
    @PushpaKumari-yp1mo 2 ปีที่แล้ว +1

    Thanku so much sir
    Very helpful and easy to understand 👍👍

  • @vaishalitiwarivlog7395
    @vaishalitiwarivlog7395 3 ปีที่แล้ว +1

    You are doing great job👍

  • @DHIRAJGE
    @DHIRAJGE ปีที่แล้ว +1

    Nice video very useful and nice explanation

  • @neerajbora5872
    @neerajbora5872 5 ปีที่แล้ว +2

    बहुत बढ़िया विडियो।

  • @amazinggopututu644
    @amazinggopututu644 ปีที่แล้ว

    Sir apne bohot hi achi tarike se sikhaya

  • @RA-rh5lb
    @RA-rh5lb 2 ปีที่แล้ว +1

    you have explained very well. thank you

  • @SimerjeetKaur3012
    @SimerjeetKaur3012 2 ปีที่แล้ว

    Thanks a lot sir to give such a wonderful knowledge how we check ur all vedios of advanced Excel with formulas

  • @sangitabhosle6632
    @sangitabhosle6632 4 ปีที่แล้ว +1

    sir
    Thanks
    Good Information
    Sir
    Give all Shoot cut keeys
    Keyboard so easily Handal and fast work Help in Excel ....
    Plzzz
    Provided video ....

  • @narottamchakraborty2951
    @narottamchakraborty2951 3 ปีที่แล้ว +1

    very nice for sharing valuable information in a simple way. Carry on!

  • @kashtiarora4603
    @kashtiarora4603 11 หลายเดือนก่อน +1

    Loving your videos

  • @Muzyyancommunication
    @Muzyyancommunication 5 ปีที่แล้ว +10

    Great Deepak you had done amazing work on sumif and sumifs formula really appreciable love from Pakistan.

    • @bscaps512
      @bscaps512 3 ปีที่แล้ว

      th-cam.com/video/1JDtiUCKjTM/w-d-xo.html

  • @sukhramrajput999
    @sukhramrajput999 ปีที่แล้ว +1

    thanks study in simple concept

  • @raghavendrapoojary6064
    @raghavendrapoojary6064 7 หลายเดือนก่อน

    Very well explained 😊 thanks.

  • @amitrelan3795
    @amitrelan3795 9 หลายเดือนก่อน

    Nice Sir❤❤❤❤ very clearly explained❤

  • @gunjakumari3184
    @gunjakumari3184 7 หลายเดือนก่อน +1

    Thanku sir

  • @TechnicalNawada
    @TechnicalNawada 6 ปีที่แล้ว +1

    jai hind sir...apka video se bhut kuchh sikhne ko mila hi..thankyou so much

  • @tapanmahalik5844
    @tapanmahalik5844 2 ปีที่แล้ว +1

    Very nice sir.

  • @nirojpradhan15
    @nirojpradhan15 6 หลายเดือนก่อน

    My problem solved with this one video.
    Thanks you so much sir
    #Odisha

  • @josephlobo3703
    @josephlobo3703 4 ปีที่แล้ว

    excellent coaching

  • @nikhilkumar-ly2yd
    @nikhilkumar-ly2yd 8 หลายเดือนก่อน

    Thanking you sir for valuable information 🙏

  • @tarunmakhal7936
    @tarunmakhal7936 6 หลายเดือนก่อน +1

    Really helpful

  • @mohammedaveshpathan5341
    @mohammedaveshpathan5341 2 ปีที่แล้ว

    You are great Deepak sir
    Excellent
    Marvellous

  • @ksk7569
    @ksk7569 2 ปีที่แล้ว

    Again thanks sir u solved my problem

  • @Engrtahirkhan
    @Engrtahirkhan 6 ปีที่แล้ว +2

    Deepak great teaching method i love from pakistan.... good luck

  • @manojsharma9959
    @manojsharma9959 4 ปีที่แล้ว

    Thanks, very nice Deepak ji.....

  • @mayankvashist1329
    @mayankvashist1329 ปีที่แล้ว +1

    Thank you, very very helpful.

  • @namrathakambli3998
    @namrathakambli3998 4 ปีที่แล้ว

    sir your videos are really great , you expalin it so well
    thankyou so so so much .

  • @sonalipandey6712
    @sonalipandey6712 ปีที่แล้ว +1

    Nice explanation

  • @gajendrakarma9228
    @gajendrakarma9228 6 ปีที่แล้ว

    deepak ji jese aapne bataya criteria formula ke bajay kisi cell me likh sakte he wesehi range ko kisi cell me le sakte he?

  • @PunamKumari-qb2ox
    @PunamKumari-qb2ox 2 ปีที่แล้ว

    Wow sir kiya batane ka tharika h majja aa gaya😊😊

  • @PrakashKumar-gn1ji
    @PrakashKumar-gn1ji ปีที่แล้ว +1

    Thank you , It helped a lot

  • @ajaylodwal4626
    @ajaylodwal4626 3 ปีที่แล้ว

    Deepak sir vhut mst pdate ho