Excel SUM Formula Series | 4 एक्सेल फार्मूला 1 वीडियो में

  Рет қаралды 78,404

My E-Lesson

My E-Lesson

Күн бұрын

This excel tutorial will cover 4 excel formulas based on SUM Formula in Excel. Download Practice Files from wp.me/p7DKaP-1bp
1 - SUM Formula in Excel in Hindi
2 - SUMIF Formula in Excel in Hindi
3 - SUMPRODUCT Formula in Excel in Hindi
4 - SUMIFS Formula in Excel in Hindi
Download Practice Files from
www.myelesson.o...
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
Top Rated Products on Amazon That You Might Like
www.amazon.in/...

Пікірлер: 74
@MohdanasMansoori-h4b
@MohdanasMansoori-h4b 7 ай бұрын
Aapka andaaz bht pasand aya sirjii
@relaxwithnature5493
@relaxwithnature5493 3 жыл бұрын
Awasome teaching skills. Wonderful 👌👌👌
@TechCareer
@TechCareer 5 жыл бұрын
Nice Video Sir...
@GuruJii
@GuruJii 5 жыл бұрын
Thanks
@nasirali4016
@nasirali4016 2 жыл бұрын
Wawooo sir you are great
@sachinraghav5865
@sachinraghav5865 Жыл бұрын
Thank you sir 🙏🙏🙏🙏
@AB-ex8ck
@AB-ex8ck 4 жыл бұрын
Superb simple and detailed learning 👌
@avii23
@avii23 3 жыл бұрын
Sir aapke videos ne bht sikha diya and saath mai aacha sense of humor ! great thanks for all this :D
@Ganesh_413
@Ganesh_413 2 жыл бұрын
Thank you sir providing for best teaching skills 🙏🙏
@rajanpandey3652
@rajanpandey3652 2 жыл бұрын
Nice sir
@GuruJii
@GuruJii 2 жыл бұрын
Thanks. To watch more video please visit www.myelesson.org/
@trooacademy2683
@trooacademy2683 3 жыл бұрын
You are simply Awesome.
@dablukumar6692
@dablukumar6692 3 жыл бұрын
Nice video sir
@tulikamall6372
@tulikamall6372 2 жыл бұрын
Awesome video!! You teach in a very interesting way Sir!
@imranalisyed9371
@imranalisyed9371 3 жыл бұрын
Thanks sir
@bhushanindiana
@bhushanindiana 2 жыл бұрын
Superb 🤩
@vishalsorathiya6803
@vishalsorathiya6803 2 жыл бұрын
Please share that how to. Compare two excell sheets with same names
@GuruJii
@GuruJii 2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@DheerajKumar-pu6su
@DheerajKumar-pu6su 5 жыл бұрын
You are doing great job...
@kannojinavnith
@kannojinavnith 2 жыл бұрын
Thank you
@narendrakumarnigam4922
@narendrakumarnigam4922 3 жыл бұрын
Thakns you sir your videos is amazing plz Carry on..
@babykhan7572
@babykhan7572 3 жыл бұрын
Very good trik 👍
@vikasjaiswalbahraich3754
@vikasjaiswalbahraich3754 2 жыл бұрын
Super
@karanvirsingh8337
@karanvirsingh8337 4 жыл бұрын
Excellent job
@priyankasurisetti2425
@priyankasurisetti2425 3 жыл бұрын
The way you teaching it is interesting to listen the video,it was extremely valuable stuff.
@VikasSingh-em3ol
@VikasSingh-em3ol 5 жыл бұрын
Super 👍 very helpful video sir
@ravisetia842
@ravisetia842 3 жыл бұрын
there is receipt of 10000 rs on account of emi 8000, overdue emi 1500and against over due interest rs 500. How to make dropdown list of emi, over due emi and overdue interest to see value by selection in the cell of recept column.
@kjl2258
@kjl2258 2 жыл бұрын
count basic salary only odd no. employee id..? how to use formula
@GuruJii
@GuruJii 2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@irfantanwar
@irfantanwar 5 жыл бұрын
Like your stuff bro Keep it up
@GuruJii
@GuruJii 5 жыл бұрын
Shukriya Irfan Bhai
@pinkyvimal16
@pinkyvimal16 4 жыл бұрын
Sir apki sabhi video bahut jaldi samjh aati h or ap ka y coaching kaha h .mai to Delhi say hu near metro gokalpuri h
@RashidKhan-ei8mn
@RashidKhan-ei8mn 5 жыл бұрын
Very good sir .kiya ap mujhe bata sakty wo kon se important formulas hai jo job ke liye zyada use hoty hai pls sir
@rrs143143
@rrs143143 3 жыл бұрын
I like your voice and smile
@devendranemadekoel1434
@devendranemadekoel1434 2 жыл бұрын
sir please explain how to do sum of evry alternate cell
@danish-oc8zf
@danish-oc8zf 3 жыл бұрын
sir plz upload excel formula most used in office like data validation n sent a link of practice files like this videos .it will be very helpful
@nikhildeshmukh2921
@nikhildeshmukh2921 3 жыл бұрын
Sir your sound tempo is little low.. But nice video.
@kripashankarsharma343
@kripashankarsharma343 5 жыл бұрын
sir ap GST Bill kaise banate hai usake bare me deeply bataye
@mehreenshaikh3303
@mehreenshaikh3303 3 жыл бұрын
Sir total ke column me automatically sum change hona chahiye cell ka digit change karne par .
@storyonly4012
@storyonly4012 5 жыл бұрын
Sir ji main AAP se sumifs sare video sikhana chahun ga jaise AAP ne kaha hai ki he 200 se Jada hai
@naveedkhawaja6327
@naveedkhawaja6327 5 жыл бұрын
Sir kaya merg function ki koi short key hai
@darshitchavda8264
@darshitchavda8264 5 жыл бұрын
awesome
@nishugarg4416
@nishugarg4416 3 жыл бұрын
hi sir what is the meaning of * in criteria in sumifs for what this sign * is used??
@mohdtarif4349
@mohdtarif4349 4 жыл бұрын
Sir kisi liquid products ko litar me convert karne ka formula batay
@mohdtarif4349
@mohdtarif4349 4 жыл бұрын
सर किसी भी लिक्विड आइटम को किलोग्राम से लीटर में कन्वर्ट करने का फॉर्मूला भी बताएं
@ashrafali-ww3go
@ashrafali-ww3go 3 жыл бұрын
Which formula where we can use them can u tell me ? I'm telling about all formulas.. Koun sa formula kab use karna hai.. Use kha par apply karna hai.. Ise par ek video bante app tho mera doubt clear hojata sir ??? Please reply me
@ArvindKumar-od6cj
@ArvindKumar-od6cj 5 жыл бұрын
Hi sir, main ek sheet banana chahta hu, for production calculate Sunday ko skip karke.
@m.adrees4239
@m.adrees4239 3 жыл бұрын
sir sumif ka formula kaam nahi kr raha kya karon plzz reply me.mene bohat koshish ki hai
@darshitchavda8264
@darshitchavda8264 5 жыл бұрын
sirjee....... i want to know that why the "*" sign put in name start with sumif formula???
@storyonly4012
@storyonly4012 5 жыл бұрын
Sir ji sumif aur sumifs dono ek saath kaise use kar sakte hai
@pintusaroj169
@pintusaroj169 2 жыл бұрын
Sar app Sam +Karna bat ya ho subtrect - ke liya nahi bata ta ho
@GuruJii
@GuruJii 2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@adilhumayun125
@adilhumayun125 3 жыл бұрын
Yeh details nikalna ho to kaise nikalenge sir Nawab bhai ko site number 25 par aur side number 30 par kitna cash diya hai aur kitna bank se 🙏 please batayein
@Jowamana
@Jowamana 5 жыл бұрын
Following although I wish it was in English!
@anubhavawasthi7102
@anubhavawasthi7102 5 жыл бұрын
superbbb sir
@anjumakhtar8688
@anjumakhtar8688 3 жыл бұрын
sir mere me tom ke 0 a rhe hai
@pinkyvimal16
@pinkyvimal16 4 жыл бұрын
Sir mujhy apsay bank m Jo bhi work hota h use releted video bano kuki mujhy bank ki job karni h isliy pls hepl me
@anjumakhtar8688
@anjumakhtar8688 3 жыл бұрын
sb kuch shi a raha hai sirf tom ka hi 0 a raha hai sir kyo
@rahularya4453
@rahularya4453 5 жыл бұрын
Sir mujhe formula error mei msg type karte hai wo video ka link send kar do
@Munkesh.Pathak
@Munkesh.Pathak 3 жыл бұрын
>50 ka to mtlb hua 50 se jada lekin aapne kaha 50 k barabar?
@juniordrive1327
@juniordrive1327 Жыл бұрын
SIR, If column A is present stock, column B is newly added stock and column C is present updated stock. then can you tell me what should be an excel formula that always shows the exact quantity of stock in column C. Even if I add multiple time new stock in column B it will also add the previous value in column B and shows the exact quantity in column C. plz Also, tell me in which column I have to apply the formula
@mitupilania8917
@mitupilania8917 2 жыл бұрын
Lcm
@mitupilania8917
@mitupilania8917 2 жыл бұрын
Please
@zaidamir3002
@zaidamir3002 3 жыл бұрын
6688 9 22 3344 6 55 11 6 0033 Is there any condition so I can find above numbers are Special numbers due to 1st & 2nd digit are same, 3rd & 4th Digit are same . On Third number 4th & 5th digit are same and 6th & 7th digit are same. Pls tell me any formula or logic in which I can find these type of Special Numbers from Data which have 1000 of numbers.
@chotayogi
@chotayogi 3 жыл бұрын
सर् , दाढ़ी क्यो बढ़ा ली ??
@RMKserve
@RMKserve 3 жыл бұрын
Innocent man
@dr.atultiwari4954
@dr.atultiwari4954 4 жыл бұрын
I am facing a strange problem. In Sum & Large (Nested) formula, Here is the process I did- I typed some figures (5,7,3,9,0,0) in cell row (C5 to C11). Now I used "IF" formula in cell row C15 to C20 instructing that if Cells C5 to C11 Contains a number that is more than 1 then put ".5" in cells C15 to C20 else display 0. It worked well & I got desired number (.5) in desired row (C15 to C20). Now problem began In Cell C21, I put SUM +LARGE formula together instructing to display "SUM of top 4 numbers from selected cell rows C15 to C20". They all carry same number / figure (.5). But it shows a "Number_Error"? I thought that formula (SUM+LARGE) is not recognizing digits contained in C15 to C20 (.5) as number because there were not typed there but appeared through "If" formula. To confirm that I used only "SUM" formula by selecting cells (C15 to C20). I thought when formula (SUM + Large) is not recognizing ".5" contained in row (C15 to C20) as number then "Sum Function" will also not recognize it as a number & will not give me total of it (C15 to C20). But I was stunned when SUM formula gave me the correct result! That means- digits of (.5) are well recognized correctly by formula but nested formula (SUME + LARGE) is showing "Number_Error". I have given up so seeking you for help. Another probability is- nested formula (SUM + LARGE) doesn't work for a row? but only for column or whole array? I don't know. Being expert in field only you can deal with this. Please help & Oblige Thanks Dr. Atul Tiwari (MD)
@vikramnamdev
@vikramnamdev 5 жыл бұрын
Ye lodu apna guru h
@shankukumar2021
@shankukumar2021 5 жыл бұрын
Thanks sir
@shankukumar2021
@shankukumar2021 5 жыл бұрын
Vlookup and hlookup apload kijiye sir
@ammar5483
@ammar5483 5 жыл бұрын
Nice sir
@rohitarora3261
@rohitarora3261 5 жыл бұрын
Thanks Sir
Why we use $ Sign in Excel Formula Explained!
18:09
Excel Tutorial
Рет қаралды 70 М.
8 Ways to Use Countif Formula in Excel in Hindi
13:59
My E-Lesson
Рет қаралды 27 М.
Sumif Formula 10 Ways to Use Sumif Formula in Excel | Hindi
13:03
pivot table for beginners in excel in Hindi | pivot table excel in hindi
23:54
5 Advance Excel Formula in Hindi
15:03
My E-Lesson
Рет қаралды 137 М.