Complete All Sum formula in excel like SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2 ETC
ฝัง
- เผยแพร่เมื่อ 12 มิ.ย. 2021
- You learn in this video Complete Sum formula in excel like SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2 AND SUMXMY2 in one video. All sum formula in excel.
#suminexcel #msexcel #allsumformula #computergyanguruji
01:00 sum formula in excel
03:28 sumif formula in excel
07:54 sumifs formula in excel
11:12 sumproduct formula in excel
13:03 sumsq formula in excel
14:51 sumx2my2 formula in excel
16:32 sumx2py2 formula in excel
17:10 sumxmy2 formula in excel
Practice file download link:
drive.google.com/file/d/1qgnM...
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Google Sheet
• google sheet
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Bahut hi badiya tha. Aise hi har formula ke group ka video upload karenge to bahut logon ko madad hogi
i have seen many videos but this video is very unique thanks a lot for making this kind of video
Guru G, you are excellent. Your way of teaching is really too good. Thanks for your time.
sir ji phli br dkha hai ki kisi ne practice k liye bhi sheet di ho wrna youtube pr smjha to dete hei pr hmare jaise lazy insaan practice n kr pate ki kha ab list bnata ghumenge...iske liye thnks and apne bhaut ache se smjhaya uske liye bhi bhaut bhaut dhnyawad apka
Thank you sir apne mera kaam asam kar diya sumif ke formule se ab me apna business me inventory ache se manage kr skya hu
Very well defined sir, easy to understand. 🙏🙏
I was very desperate to solve my problem and that i got it from you this video. Thanks
Your tutorial is very efficient to us than other you tube videos
വളരെയധികം ഉപകാരപ്പെട്ടു 👍👍
सर आपका पढ़ने का तरीका बहुत अच्छा है और हमें बहुत पसंद आया tanks-a-lot sr,,, I like ofyour teaching method ❤❤
नमस्कार सर,
मैं अध्यापक हूँ. पढना-पढाना जनता हूँ. और आपका पढाने का तंत्र देखकर प्रभावीत हूँ. आप और और कोई है जो पढाने का तंत्र सीखा है या नाहीं मैं जनता नहीं, लेकिन पढाते हो बहोत खूब.
विषय की क्या बात करे. किसीं ने भी सीखा तो कमाने लगेगा. बहोत काम का विषय आप सिखाते हो. आप बडे प्रामाणिक है. किसीं व्यक्तीने जो नाराजी जताई ओ आपने जाहीर की. मुझे इसी बात पर व्यक्त होणे की आवश्यकता महसूस हुई.
कोई कुच्छ भी बोले. लेकिन आपकी सीख बहोत काम की है. कोई फ्रॉड नहीं. काम करते समय गलती हो जाती है. फंक्शन काम नहीं करता. बस अपनी गलती.कोई और कैसे फ्रॉड होगा. आप से और दीपक नेहरा, और लोकेश लालवानी सर से बहोत सीखता हूँ. मन से धन्यवाद देता हूँ. बहोत अच्छे सीट बनाता हूँ. आनंद लुटता हूँ.
आपका मन से धन्यवाद!
हार्दिक शुभ कामनांऐ!
Kich pi kr likha h aisa lag rha h
Outstanding! Best regards from Limón, Costa Rica!
Bahut bahut dhanywad mahashay aap bahut pratibhashali hai
It is a wonderful video. Thank you Sir......
Nicely explained , thank you so much
Thank you so much Gurudeo. The way you teach is excellent.
It's good strategy to teach us. I would request you to please make video same for other basis formula as well like - Count, If, etc. Thanks for amazing videos😀😀.
Helpful video and explained very well...
this is the helpful for basics learner and also explanation is good(all formulla are very useful)
Very nice video and this is very helpful for all. Teaching way is very effective😊
Sir you understand very well thankyou very much sir
really really you are a very good teacher.
I have seen many videos on excel tutorial but sir ur teaching style is outstanding and very comprehensive so from now on u are my excel guru keep blessing us with informative videos thank a lot sir 🙏
thank you
@@ajitsurvase0935 Aaàa
Mene advanced excel ka caurse kiya tha abhi fir bhi mujhe un sir se smjh ni aya lekin apke samjhaane ka tarika itna acha h ki sb clear ho gya thank you so much sir 🤍🙇,
🎉🎉
Very good👍
your videos are easy to understand and really helpful. Thankyou for making us understand easily.
Very nicely explained. Thanks.
Sir,I I am really thankful to you because the way of teaching is fantastic . it is amazing because it is really comprehensible.
I learned it . Please keep on for ever.
❤❤❤❤❤ sir you are explaining for the best of all methods
very good tutorial sir... great lesson
thanks. i was looking for solution which i got through sumif formula as you described. Regards
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
You are great understanding for me thank you so much sir
Very nice you are great teaching 👍👍
Sir your teaching is very clear and nice.
very well explained sirji....
Thanks for your kind information.
Good night sir,
Thank you so much sir
Very useful video
Sir your way of giving knowledge amazing keep it up and make these type of videos to help us
Very good explanation 🙏
Thanks for the video, you explain every single point in detail.
Very Helpful and easy to understand
Very Nice Experience.....!!!
Thanks, Very helpful
Bahut achha sir ji TQ aap achhi tarah se samjhate hain tq❤❤❤❤❤
Sir m aap ka avi video dekha or bahut acha h, aj se m v aap ka subscriber hu
excellent extra ordinary outclass lecturer
Weldone aap bohat acha samjhatay hain.
Complete account software with manufacturing inventory banana sekhayay ga.
Thanks for your guidance sir
Thank you for share great information with us am from Pakistan
Thank you so much Sir 🙏
Aap bhut achhe se explain krte ho
Respected Sir. Keep doing good
Excellent Sir. 👍
very nice sir thank you so much
Fantastic video, thanks
KNOWLEDGEFUL VIDEO
Thank u sir aapki wajah se aaj me hr ki post pe hu ❤❤
Very nice sir thank you so much
you are my excel dear elder brother
Sir you are explain very well
👍Sir Super teaching
thanks .
sir for giving me information
You are fabulous sir
Sir, aapne sum ke liye Jo short key batya tha vo nahi ho pa Raha hai.
loved the class
Thank you sir!
Aap bohat acha tarika sa samjhata ha
kay video ma aap hindi likhta ha Urdu ma b likha kara
(Yousaf) Lahore Pakistan
Lagta he sir Rajasthan se he Voice are very clear
Both both shukirya ma aap ka videos dekh ka class data hu
Bohat Shukariya Sir
बहुत बढ़िया है sir
Thank you so much sir I like 👍
Nice sir very well i am pakistani you are good teacher
Excellent video
Thanks a lot.
Sir आपके पास PDF है क्या
THANK YOU VERY VERY MUCH
Thank you so much sir
I am from Pakistan, your teaching style is good, I wish to learn MS Project, kindly guide me
❤ very useful
Sir count ka bhi isi tarah video banaye 👌
Thanku sir 🎉🎉🎉🎉🎉🎉🎉🎉
Sir Thanks 🙏....
Worked, thx
Excellent bro ....
Sir if there are comma's in numerical figure in a table in word, the how to use sum or any other formula as it is giving wrong calculation
In case of RAM when I am Applying Ram the sumif value is showing zero. Why?
Thank you sir 🙏
Hello Sir, Thanks to you also add some excel sheet link for prcatical
Great sir🙏🏼🙏🏼
Thanks for your time
Well explained
Very very good, good jod
Very much thankful
realy helpful to us
Sir u r brilliant
Great ho aap sir
Hi sir, please make a video as employee attendance shift roster, approximately 25 staff and 04 shifts
Sir very benefit video ha
بہت شکریہ سر
Thanks for all this
Good one, but How to use SUMIFS formula for getting other sheet data