Formula of Sum Average Count Min Max in Excel - How to use formula in excel in Hindi | Part-28

Подписаться 1,3 млн

Просмотров 2,7 млн

50% 1

Follow @Twitter: / ishanllb
Follow @Instagram: / ishanllb
Join Our Telegram Channel : t.me/ishanmonitor
My Mic : amzn.to/2CYC2k2
My Camera : amzn.to/394SD1Y
My CPU : amzn.to/2U58Boj
My Monitor : amzn.to/2wnX4rf
Website : www.ishanllb.co
Formula of Sum Average Count Min Max in Excel - How to use formula in excel in Hindi | Part-28
is video me aap janege ki excel me formula kaise lagaya jata hai aur sum formula kya hai, average kaise nikalte hai hai min max formula kaise use karte hai.
1) SUM: पहला एक्सेल फ़ंक्शन जिससे आप परिचित होने चाहिए, वह है SUM जो addition के बेसिक अरिथमेटिक ऑपरेशन करता हैं। SUM फ़ंक्शन का syntax इस प्रकार है: SUM(number1, [number2] ,…)
Example : =SUM(A1:A5)
2) AVERAGE: एक्सेल का AVERAGE फ़ंक्शन, नंबर्स का औसत (arithmetic mean) खोजता है। AVERAGE फ़ंक्शन का syntax इस प्रकार है: AVERAGE(number1, [number2], …)
Example : =AVERAGE(A1:A5)
3) MAX & MIN: Excel में MAX और MIN फार्मूला क्रमशः, नंबर्स के सेट की सबसे बड़ी और सबसे छोटी वैल्‍यू होती हैं।
Example : =MAX(A2:A5) and =MIN(A2:A5)
4) COUNT & COUNTA: यदि आप यह जानना चाहते हैं कि सेल्‍स रेंज में कितने सेल्‍स में न्यूमेरिक वैल्‍यू (numbers or dates) हैं, तो इन्‍हे मैन्‍यूअली गिनने में अपना समय व्‍यर्थ न करें। एक्सेल का COUNT फ़ंक्शन एक ही सेकंड में गिनेगा।
Example : =COUNT(A:A)
Watch Other Parts Here :
Computer Education Part-1 : • Computer Education Par...
Computer Education Part-2 : • Computer Education Par...
Computer Education Part-3 : • Computer Education Par...
Computer Education Part-4 : • Computer Education Par...
Computer Education Part-5 : • Computer Education Par...
Computer Education Part-6 : • Computer Education Par...
Computer Education Part-7 : • Computer Education Par...
Computer Education Part-8 : • Computer Education Par...
Computer Education Part-9 : • Computer Education Par...
Computer Education Part-10 : • Computer Education Par...
Computer Education Part-11 : • Computer Education Par...
Computer Education Part-12 : • Computer Education Par...
Computer Education Part-13 : • Computer Education Par...
Computer Education Part-14 : • Computer Education Par...
Computer Education Part-15 : • Computer Education Par...
Computer Education Part-16 : • Computer Education Par...
Computer Education Part-17 : • Video
Computer Education Part-18 : • Computer Education Par...
Computer Education Part-19 : • Computer Education Par...
Computer Education Part-20 : • Computer Education Par...
Computer Education Part-21 : • Computer Education Par...
Computer Education Part-22 : • Computer Education Par...
Computer Education Part-23 : • Computer Education Par...
Computer Education Part-24 : • Computer Education Par...
Computer Education Part-25 : • Computer Education Par...
Computer Education Part-26 : • Computer Education Par...
Computer Education Part-27 : • Computer Education Par...
Tags: Formula of Sum Average Count Min Max in Excel,How to use formula in excel in Hindi,computer education part 28,Excel Formulas Hindi,excel in hindi,excel classes in hindi,online excel class in hindi,how to learn computer in hindi,computer kaise sikhe,excel chalana kaise sikhe,excel ishan llb,excel by ishan,Excel Formulas,Learn Excel Course in Hindi,sum formula in hindi,average formula in hindi,excel formulas with examples in hindi,excel me formula kaise lagaye

Наука

Опубликовано:

1 июл 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 959

@jyotitanty1860 4 года назад

Sir aap ka video dekhne ke bad or kisi ka video dekhne man nahi karta kyun ki aap ka samjhane ka tarika bohut acha h thank u sir

@ncertlearningpoint 2 года назад

Re ew Wow nice w hajjhggffffx tee shirt et al j

@ncertlearningpoint 2 года назад

Ok par hai to kuchh hai nahiT error occurred when activating the hai ki oiiu the hai opmbgl

@vimalmaurya6993 2 года назад

Right 👍

@VijayKumar-yb3xf 2 года назад

Ek dam sahi bole bhai

@soniyagahlot9287 2 года назад

Very good acha samanj main aya

@gourabhsharma4154 Год назад

Mene RU-vid pr sabhi videos dekhi hai but aap jis prakar samjhate ho bo jyda better laga ❤ 👍 thank you sir

@death_dev_9951 3 года назад

Bhout acha Se samjha h bro ek he bar me samjhe aa gya 😍😍😍😍😍😍😍

@Pinkukumari5577 2 года назад

Thank you sir ❤ Video vhut ache h Ek baar m hi sare formula yaad ho gye

@durgeshtrakpts Год назад

Thankyou sir..video dekhne se phle yahi lagta tha ki bhot though hai ye formula but dekhne ke bad bhot easy laga sir likhe ki jrurt hi nahi padi sab Yad ho gaya thanks from bottom of my heart❤️🙏

@Bkqureshi Год назад

Video bahut देखे sir lekin ye sabse alag thi thanks for this knowledge

@sabihanaaz3774 9 месяцев назад

Your voice, your way of talking is excellent.Thank you sir.

@vinodjyoti6211 Год назад

Bhut acchi tarh se samjh AA gya sir formula ka use karna.verry good

@simpleexcelexamples9619 2 года назад

Great video sir, great content, just simple and to the point, great voice to listen too: THANK YOU 😊

@sonalidubey7628 3 года назад

Aap Bhut clearly explain krte hai very nice video sir 🙏🙏

@saurabhsharmag1567 11 месяцев назад

Hii

@user-yx4zc7uz3n 5 месяцев назад

Sir Aap bahut Achche hai Mein Isse formula Lagane Ki Koshish Karta hoon

@mdsajjad7746 3 месяца назад

Thank you sir aap bahut achha samjhte hai or bhi achhi achhi video late rahiye ayse hi sir

@uddiptatg 5 лет назад

Make a pdf including all the formulas of excel and send in the description. I always thankful for you and your helpful videos. I really feel more help from your video. HUGE THANKS

@mithileshtripathi8 3 года назад

Thank you sir . It was very helpful for me☺️👍👍

@soniasoniasingh7897 2 года назад

Sir, thank you so much ap itne ache se samjhte ho me apke alawa kisi ki video nhi dekhti ......

@shailendramishra1129 Год назад

Sir itna accha video aaj tak maine kabhi tak nahi dekha hai sir thank you so much

@sajaadsheikh5352 3 года назад

I started from zero but u make me hero.... Helps a lot. Tyx u so much. God bless u always dear bro. ❤️❤️

@alicesunilchakmawounderfuldest 3 года назад

Very helpful or much stills interesting vedio.. thanks u very much for your.. teaching.🇮🇪🇮🇪🇮🇪🙏

@dvrfamily3201 2 года назад

Sir aap itni acchi tarah samjhatey hai har ek cheez yaad ho jati hai aap jaise teacher ko salute hai sir

@SHAHNAWAZKHAN-ry6zd Год назад

Thank you so much sir is video se mere sabhee doubts clear ho gye h🙏

@bijaydokania2556 3 года назад

very very good video, keep making more & more productive video like this

@abhijeetfragrance1574 3 года назад

Mind blowing sir bahut sundar aur achhe se samjhate ho aap 🙏🙏🙏🙏🙏

@khushbugupta850 3 месяца назад

Sir aap Jo v samjhae wo sab samjh me 1 hi baar me aa gaya thanku sir I m proud of you 😊

@mannurawatvlogs 2 года назад

Your great sir mujhe thoda bhut Formula's ata tha lekin apne jo samjhaya ek mint main pura samhj agaya thanks you Sir😍

@VivekVerma-ur4nr 4 года назад

Thank you sir....most valuable Excel video

@moumitamondal7368 3 года назад

Thank you so much. It's really helpful.

@satishchandra1163 Год назад

Sir aap bahut hi badiya aur bahut easy tarike se samjhate ho👌aapka video dekhne ke baad aur video dekhne ki jaroorat hi nai padti...sir ji thank you ..

@nibhakumari4713 Год назад

Sir aap bahut achha se padhate hai

@wecandothis7621 2 года назад

Very easy to explain thank you so much sir I'm fresher...

@rajnijoshi9307 3 года назад

thak you for good information of excel format in detail

@gopalsharma-zu3yb 3 года назад

Aapki video na muja bhot kuch sikhaya thank you sir

@anshulkumar733 2 года назад

Sir bhut bhut dhanyawad sir . Sir apne bhut badiya padaya hain sir esa hi padana chaya sabhi ko sir apne Jo life me important hain only vhi bataya hain aur video me time waist nhi kiya jo sikhana chaya vo sikhaya ....esi video banaya karo sir hamesa ..... Thank you sir....

@amoshturuk8988 3 года назад

I learnt many more things only for your teaching so except thanks I have no word thanks for excellence teaching

@vimalsahu5668 3 года назад

Thank you very much Ishan Ji, It is like a magic,God bless you.

@vandanaprajaptavi4035 2 года назад

Sir app sch me bot ache se samjha te ho koy bhi nhi samjha ta ase tq sir me app ke hi video dekhungi ab kisi se nhi ❤️

@ajaytiwari7102 10 месяцев назад

I am very happy with you sir your formula is very good

@minalrathore495 4 года назад

I was searching many videos but I didn't get that I want but only your video make me calm😇😇... Thanks u so much. I have my computer practical tomorrow so your video really helped me. Thanks once again🤘

@espoirdz9775 3 года назад

boutic.sissina.1tpe.fr/

@glorysobhanaik8654 2 года назад

Sssso beautiful and understand teaching 🙏🙏🙏🙏🙏

@noornaushad5743 2 года назад

aap ki video dekh k acha lsga bilkul aasan triqe se samjhaya hai aapne

@sikarplus2356 Год назад

Sir aap bhut acchi thara se samjha rahe h. Thanks sir. Mujhe aap ka video bhut pasand aaya.

@sureshchandrajena9134 4 года назад

Bhaiya. Th5ank you so much. Let us teach other formulas like sumif count if etc.

@saurabhkoranga8913 3 года назад

Thank you so much sir this video is helpful for me 🙏🙏

@jemmy_is_happiness Год назад

Sir kitne acche tarike se samjhate Hain bahut acche tarike se aap explain Karte Hain

@SumitKumar-qu9ki 2 года назад

You Are Great Sir

@mohdrafiq8764 3 года назад

Thank you sir! Very helpful commands.

@deepakreasoning1234 4 года назад

Mind glowing sir..

@PoojaSingh-xx2pw 2 года назад

Such a apka ka hi video follow karte hai.... Thanku so much

@shivanibhargav8921 Год назад

Thanks sir bhot achha shikhate ho 1 bar me aasani see samajh aa gya

@sunilkumar-br9nz 3 года назад

thank you sir for save my time and money..

@sapnanegi8406 4 года назад

Thank you so much sir🙏🙏🙏🙏

@Rsconfig 2 года назад

Bahut achha apne samjhaya ek bar me sab samjh aaya

@AkashKumar-gr5mb Год назад

Sir maine aap ka veido pehali bar dekha bahuth achhi tarh se samjh me aaya thankq sir🙏

@brijpalsingh7366 3 года назад

Thank you sir for learn me about computer[]

@sbentertainment4835 3 года назад

Thank you

@manishkumarjha4090 4 года назад

You are my first computer teacher 🙏

@Tushar-wu7pf 4 года назад

www.quora.com/q/pydircgiyhtflnaf/Microsoft-Word-Shortcuts-Key?ch=10&share=26bda887

@dataandscience 2 года назад

Nice Tutorial. Easy to understand. Keep going same way...................

@marryngarryrecord5069 2 года назад

Thanks sir for advance knowledge dene k liye🙏

@HamidRaza-wb3od 3 года назад

Bahut hi easy way me explain karte hain ishan sir.❤️fully certified 🔥

@vinayhasija1007 3 года назад

Thanku sir...aapki video kaafi acchi thi...kya aap accounts, tally related videos bhi bana skte hain...

@niranjansinghdangi4490 2 года назад

बहुत-बहुत धन्यवाद भाई

@shabnamali3721 2 года назад

Bhut hi ache se smjhaya hai apne ..qr cod bhi btaye ..or onlin bill kaise bnaye

@amjadkhan8513 4 года назад

क्या बात है भाई... same आप जैसे जैसे बोलते गए मैं वैसे वैसे करते गया.. बहुत अच्छा लगा बड़े भाई..👍 सिख गया थोड़ा बहुत..

@babusinghchavada1112 4 года назад

सेक्स कोट्स

@rajdosanjh107 3 года назад

Thank you sir🙏🙏🙏

@Sujatask-wh1ow 2 года назад

Every nice video sir aap ke video bahut help karta h mujhe mere computer class me excel chal rha h aap ka video dekh ke mai sab farmula laga leti hu bahut bahut dhanyavaad sir

@paintmyworld1893 Год назад

Sir you are the best teacher for computer education

@jeevanbage3852 3 года назад

Great RU-vid Teacher of the time sir. Thank you so much and congratulations.

@soniyathakur5009 3 года назад

Thank you sir

@astronazamgarh1889 2 года назад

Wow sir kya smjhate hai ap

@astronazamgarh1889 2 года назад

Sir apka kitne bje se class chalta hai hm apke nye student hai

@astronazamgarh1889 2 года назад

Sir please time bat dijiye hmko apki class bht acchi lgi

@Itzshiva238 3 года назад

Thank you sir...

@SurekhaKumari-fz5sb 9 месяцев назад

Sir ap bahot hi acche se samaghaye ho🙏

@sushmaraikwar3429 Год назад

Thanku so much sir me formula yad n kar pa rahi t par apke video ne bahut asani se sikha diya thankyou so much sir 🙏🙏🙏🙏🙏🙏🙏

@meherunnisabegummeherunnis9797 2 года назад

Nice Thnku sir aur dusra tarikha batayiye sir jaise recipsnist job karre to waha kaise kya kya karna padega computer me. Aur scanning file Kaise nikaalna Wo b batayiye plzzz

@milanrai6987 3 года назад

Thank you sir 🙏

@manojkumarmanojkumar8800 2 года назад

Bahut achha lagraha bhaiya appki padhaneka tarika thank you so much

@mdrajahasan6641 3 года назад

Thank you sir ☺

@navnitpandey5555 3 года назад

ईश्वर से कामना करते है कि आपका चैनल जल्द ही और सफल हो

@kindergartenbench 3 года назад

Very nice way of explanation.....really useful ....Big Thumbs Up!!

@somdattkumar7990 3 года назад

Aap ke vedio se Maine bhi ek formula seekha hai Jai ho aap ki

@bushrafatima4397 4 года назад

Thank you so much Brother..

@jitendrasaini178 2 года назад

Bahut hi aasaani se samjhate ho sir aap

@mera950 3 года назад

Tyqq boss itna achha to mera teacher pese lekar bhi nhi sikhata h tyqq so much

@Amandeep-sb5sc 3 года назад

(Direct select the cells and go in the auto sum section and click on the option whatever you want to find) This method is far better then applying formula 😅 But yaa if we will apply formula then whenever change the digits it will give us direct total result ✌️ Thank you Ishaan Bhaiya for these type of tutorials ♥️🙏