Excel SUM Formula Series | 4 एक्सेल फार्मूला 1 वीडियो में
Vložit
- čas přidán 23. 08. 2024
- 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/...
Aapka andaaz bht pasand aya sirjii
Awasome teaching skills. Wonderful 👌👌👌
Sir aapke videos ne bht sikha diya and saath mai aacha sense of humor ! great thanks for all this :D
Wawooo sir you are great
Thank you sir 🙏🙏🙏🙏
Awesome video!! You teach in a very interesting way Sir!
The way you teaching it is interesting to listen the video,it was extremely valuable stuff.
Superb simple and detailed learning 👌
Thank you sir providing for best teaching skills 🙏🙏
Thanks sir
Thakns you sir your videos is amazing plz Carry on..
Nice video sir
Nice Video Sir...
Thanks
Nice sir
Thanks. To watch more video please visit www.myelesson.org/
Thank you
You are simply Awesome.
Please share that how to. Compare two excell sheets with same names
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
You are doing great job...
Super
Superb 🤩
Super 👍 very helpful video sir
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.
Very good sir .kiya ap mujhe bata sakty wo kon se important formulas hai jo job ke liye zyada use hoty hai pls sir
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
Excellent job
count basic salary only odd no. employee id..? how to use formula
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
Very good trik 👍
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
Like your stuff bro
Keep it up
Shukriya Irfan Bhai
I like your voice and smile
Sir total ke column me automatically sum change hona chahiye cell ka digit change karne par .
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
Sir ji main AAP se sumifs sare video sikhana chahun ga jaise AAP ne kaha hai ki he 200 se Jada hai
Hi sir, main ek sheet banana chahta hu, for production calculate Sunday ko skip karke.
sir please explain how to do sum of evry alternate cell
sir ap GST Bill kaise banate hai usake bare me deeply bataye
Sir your sound tempo is little low.. But nice video.
awesome
hi sir what is the meaning of * in criteria in sumifs for what this sign * is used??
sir sumif ka formula kaam nahi kr raha kya karon plzz reply me.mene bohat koshish ki hai
sirjee....... i want to know that why the "*" sign put in name start with sumif formula???
Sir kaya merg function ki koi short key hai
Sir kisi liquid products ko litar me convert karne ka formula batay
सर किसी भी लिक्विड आइटम को किलोग्राम से लीटर में कन्वर्ट करने का फॉर्मूला भी बताएं
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
Sir ji sumif aur sumifs dono ek saath kaise use kar sakte hai
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
Sir mujhe formula error mei msg type karte hai wo video ka link send kar do
Following although I wish it was in English!
superbbb sir
Sar app Sam +Karna bat ya ho subtrect - ke liya nahi bata ta ho
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
sb kuch shi a raha hai sirf tom ka hi 0 a raha hai sir kyo
sir mere me tom ke 0 a rhe hai
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.
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
>50 ka to mtlb hua 50 se jada lekin aapne kaha 50 k barabar?
Lcm
Please
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)
Innocent man
सर् , दाढ़ी क्यो बढ़ा ली ??
Ye lodu apna guru h
Thanks Sir
Nice sir
Thanks sir
Vlookup and hlookup apload kijiye sir