Excel Sumif Function | Sumifs formula in excel in hindi 

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.

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

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

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

Great teacher

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

Sir aapka explain karneka tarika awesome 😎 hai

Thanku so much guru Ji 🙏

Your videos are blessings for me sir

Wah dost Kitana acha method samjha rahy aappp😊

thanks a lot

Thanku sit

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

beautiful explanation

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

Brilliant Sir 👌👌👌👌👌👌

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

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

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

❤❤❤❤

Thanks sir but me jis company me kam karta hun Yahan excel me jo formula sumif ka use hita he

Selfish people. 53k views and likes less than 2k.

I am geting error .... =SUMIFS(Mines!H4:H5047,Mines!C4:C5047,">="&Home!C4,Mines!C4:C5047,"

Kya samjaya aap nai

Nyc sir

Nice video ❤❤

❤❤❤❤❤

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

If the value is up to 100 then minus 50 from the value amount or if the value is >100 then the value is equal. Formula pls

Deepak sir i want purchase short trips vba code plz give me vba shot trips code ...?

In this sheet, the sum range is available vertically, so it easy, but when the sum range is in horizontal manner. Then how can we find it please...

I want total of a person one time and zero in other cells if name is more than one time.

Hi Sir Agr line khtm ho Jay to plus and minus sum b OSE line khtm ho Jay Es ko Kesy khtm kareen . Har line ka Sam usi line per khatm hona Chahey

sir how to identify sum range like question should be changed so how can we identify sum ka range kaisy lain gai sir?

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

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

Time in out multiple times in a single day. But total should be in one cell other in out cell total should be empty

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

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

Sir ek Excel ka shortcut key ka video banaye

Hello sir plz btao ki ansh ke east aur west dono ka total kese ayega plz formula btao sir

Sir ak question hy uska solution chahiye tha bat send kyse Karu

You are amazing need your assistance regarding a formula

How to freeze that criteria?

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

Large data me sumifs kaise kare range samaj nahi aa rahe condition more than 10 hain

Hlo sar

bahut achhe smjya apne concept clear ho hya sir thanku

Sir formula Freez ke liye kon sa Key use karte hain

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

Always happy learn from you ❤️thanks a lot sir

We can easily create sumif formula with the help of excel vba Sub sumif() Range("b9").Value = Application.WorksheetFunction.sumif(Range("a2:a8"), 1680, Range("b2:b8")) End Sub #excel #vba #excelvba #microsoftexcel #microsoftoffice #data #sum #sumif #vbamacro #vbacode #excelformula

Best line "Renga", "maharang"

so nice sir, today i reched at video #29 in excel mis series of 73 vides, I want to continue this journey with you, till sql, is it possible that you will take me to that level, please continue serial wise like, I am a big fan of yours. Thank you so much sir

freeze short cut kya use karte hai sir

U are to good sir

Sir please folder ka name batayenge?? Jahapar yea practice data hain??

Sir frez q karte hai agr hm Vlookup hlookup sumifs...... Me agr hm sabme frez kre to koi problem to nhi hogi

Sir short cuts kyes Bataye

I want to short out my some problem.

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.

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

Sir want ask something different type of sum , I m facing difficulty, can u help me sir

=IF([@[task_type]="pickup",[@supplier_id],[customer_id]]) - why this is not working? can anyone help me pls.

Thank you so much🙏 sir jii

Thanku sir

Nice 👍 explain vedio

Sir ye sumif aur sumifs isse acha pivot table se hojaega n aap apne styles se sikhaiye please 👏🏻 @innozant

excellen sir, but i have a question i think it is by using fliter funtion. please tell if i am wrong

Excellent

Sir laptop keyboard me formula freezing ke liye f4 ki jgha ky type kare

vlookup and sumif

Sir what is the meaning of S in Sumifs. I mean I want to know the fullform of S is used after Sumif(s). I hope you got it. Please help I am unable to get this answer.

Bhai sidha simple formula bhi use kar sakte hai freeze kyon kar rahe ho

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

Sir ap na lock kesay kiya ha single step sa hi??? At the moment 👉 03:38

Gm sir.. Sir sumifs karte samay criteria range select karne ke bad,mera criteria Marge cell hai to sumifs formula kam nahi karha hai.. Please help me..

Method is very good

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

how can we freeze the formula directly ....

Thank u so much sir..

This person shpuld have a million subscribers

Thank you such sir

Sir i am unable to sum a column with a criteria of .can you pls help

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

Fatafati.....

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

Super sir👌💯👌👌

thank you Sir ji

Dhanywad mhoday

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

Love for you

Thank you sir.....

Happy Rakshabandhan sir. Happy learning

I love you sir 😊

Amazing talented

your one of that lline "range hain ya rangvaa" is very funnnny

Thank you Sir

thanks a lot sir

thanks a lot sir