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

Ғылым және технология

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

Пікірлер: 961

  • @simpleexcelexamples9619
    @simpleexcelexamples96192 жыл бұрын

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

  • @jyotitanty1860
    @jyotitanty18604 жыл бұрын

    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

    @ncertlearningpoint

    2 жыл бұрын

    Re ew Wow nice w hajjhggffffx tee shirt et al j

  • @ncertlearningpoint

    @ncertlearningpoint

    2 жыл бұрын

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

  • @vimalmaurya6993

    @vimalmaurya6993

    2 жыл бұрын

    Right 👍

  • @VijayKumar-yb3xf

    @VijayKumar-yb3xf

    2 жыл бұрын

    Ek dam sahi bole bhai

  • @soniyagahlot9287

    @soniyagahlot9287

    2 жыл бұрын

    Very good acha samanj main aya

  • @sabihanaaz3774
    @sabihanaaz37749 ай бұрын

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

  • @Pinkukumari5577
    @Pinkukumari55772 жыл бұрын

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

  • @gourabhsharma4154
    @gourabhsharma4154 Жыл бұрын

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

  • @sajaadsheikh5352
    @sajaadsheikh53523 жыл бұрын

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

  • @death_dev_9951
    @death_dev_99513 жыл бұрын

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

  • @vinodjyoti6211
    @vinodjyoti6211 Жыл бұрын

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

  • @durgeshtrakpts
    @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
    @Bkqureshi Жыл бұрын

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

  • @soniasoniasingh7897
    @soniasoniasingh78972 жыл бұрын

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

  • @user-yx4zc7uz3n
    @user-yx4zc7uz3n5 ай бұрын

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

  • @sonalidubey7628
    @sonalidubey76283 жыл бұрын

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

  • @saurabhsharmag1567

    @saurabhsharmag1567

    11 ай бұрын

    Hii

  • @minalrathore495
    @minalrathore4954 жыл бұрын

    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

    @espoirdz9775

    3 жыл бұрын

    boutic.sissina.1tpe.fr/

  • @shailendramishra1129
    @shailendramishra1129 Жыл бұрын

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

  • @mdsajjad7746
    @mdsajjad77464 ай бұрын

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

  • @abhijeetfragrance1574
    @abhijeetfragrance15743 жыл бұрын

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

  • @mithileshtripathi8
    @mithileshtripathi83 жыл бұрын

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

  • @dataandscience
    @dataandscience2 жыл бұрын

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

  • @SHAHNAWAZKHAN-ry6zd
    @SHAHNAWAZKHAN-ry6zd Жыл бұрын

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

  • @bijaydokania2556
    @bijaydokania25563 жыл бұрын

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

  • @VivekVerma-ur4nr
    @VivekVerma-ur4nr4 жыл бұрын

    Thank you sir....most valuable Excel video

  • @dvrfamily3201
    @dvrfamily32012 жыл бұрын

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

  • @gopalsharma-zu3yb
    @gopalsharma-zu3yb3 жыл бұрын

    Aapki video na muja bhot kuch sikhaya thank you sir

  • @alicesunilchakmawounderfuldest
    @alicesunilchakmawounderfuldest3 жыл бұрын

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

  • @moumitamondal7368
    @moumitamondal73683 жыл бұрын

    Thank you so much. It's really helpful.

  • @MukeshKumar-il5cf
    @MukeshKumar-il5cf5 жыл бұрын

    Fantastic video sir......Mai aapke video se bahut hi knowledge multi hai

  • @satishchandra1163
    @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 ..

  • @rajnijoshi9307
    @rajnijoshi93073 жыл бұрын

    thak you for good information of excel format in detail

  • @uddiptatg
    @uddiptatg5 жыл бұрын

    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

  • @nibhakumari4713
    @nibhakumari4713 Жыл бұрын

    Sir aap bahut achha se padhate hai

  • @mannurawatvlogs
    @mannurawatvlogs2 жыл бұрын

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

  • @vimalsahu5668
    @vimalsahu56683 жыл бұрын

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

  • @amoshturuk8988
    @amoshturuk89883 жыл бұрын

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

  • @SumitKumar-qu9ki
    @SumitKumar-qu9ki2 жыл бұрын

    You Are Great Sir

  • @kindergartenbench
    @kindergartenbench3 жыл бұрын

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

  • @wecandothis7621
    @wecandothis76212 жыл бұрын

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

  • @deepakreasoning1234
    @deepakreasoning12344 жыл бұрын

    Mind glowing sir..

  • @PoojaSingh-xx2pw
    @PoojaSingh-xx2pw2 жыл бұрын

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

  • @ayushyaav684
    @ayushyaav6843 жыл бұрын

    Thankuewww so much sir. Aesi hi aur information Dette rahena aap

  • @sunilkumar-br9nz
    @sunilkumar-br9nz3 жыл бұрын

    thank you sir for save my time and money..

  • @saurabhkoranga8913
    @saurabhkoranga89133 жыл бұрын

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

  • @khushbugupta850
    @khushbugupta8503 ай бұрын

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

  • @ajaytiwari7102
    @ajaytiwari710210 ай бұрын

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

  • @glorysobhanaik8654
    @glorysobhanaik86542 жыл бұрын

    Sssso beautiful and understand teaching 🙏🙏🙏🙏🙏

  • @sureshchandrajena9134
    @sureshchandrajena91344 жыл бұрын

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

  • @vandanaprajaptavi4035
    @vandanaprajaptavi40352 жыл бұрын

    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 ❤️

  • @niranjansinghdangi4490
    @niranjansinghdangi44902 жыл бұрын

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

  • @HamidRaza-wb3od
    @HamidRaza-wb3od3 жыл бұрын

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

  • @mohdrafiq8764
    @mohdrafiq87643 жыл бұрын

    Thank you sir! Very helpful commands.

  • @SalmanKhan-er2yu
    @SalmanKhan-er2yu4 жыл бұрын

    Sir Kya knowledge deto ho Aap maza Aa gaya bhai Allah Aapko salamat rakhe ishan bhai

  • @paintmyworld1893
    @paintmyworld1893 Жыл бұрын

    Sir you are the best teacher for computer education

  • @sapnanegi8406
    @sapnanegi84064 жыл бұрын

    Thank you so much sir🙏🙏🙏🙏

  • @manishkumarjha4090
    @manishkumarjha40904 жыл бұрын

    You are my first computer teacher 🙏

  • @Tushar-wu7pf

    @Tushar-wu7pf

    4 жыл бұрын

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

  • @marryngarryrecord5069
    @marryngarryrecord50692 жыл бұрын

    Thanks sir for advance knowledge dene k liye🙏

  • @sikarplus2356
    @sikarplus2356 Жыл бұрын

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

  • @jeevanbage3852
    @jeevanbage38523 жыл бұрын

    Great KZread Teacher of the time sir. Thank you so much and congratulations.

  • @soniyathakur5009

    @soniyathakur5009

    3 жыл бұрын

    Thank you sir

  • @astronazamgarh1889

    @astronazamgarh1889

    2 жыл бұрын

    Wow sir kya smjhate hai ap

  • @astronazamgarh1889

    @astronazamgarh1889

    2 жыл бұрын

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

  • @astronazamgarh1889

    @astronazamgarh1889

    2 жыл бұрын

    Sir please time bat dijiye hmko apki class bht acchi lgi

  • @brijpalsingh7366
    @brijpalsingh73663 жыл бұрын

    Thank you sir for learn me about computer[]

  • @sbentertainment4835

    @sbentertainment4835

    3 жыл бұрын

    Thank you

  • @bhavikajadav2229
    @bhavikajadav22292 жыл бұрын

    superb sir..sabse achha apne samjaya.. thanks

  • @abdulqamar007
    @abdulqamar0073 жыл бұрын

    very good sir samjhane ka tarika apka bhut accha hai

  • @amjadkhan8513
    @amjadkhan85134 жыл бұрын

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

  • @babusinghchavada1112

    @babusinghchavada1112

    4 жыл бұрын

    सेक्स कोट्स

  • @rajdosanjh107
    @rajdosanjh1073 жыл бұрын

    Thank you sir🙏🙏🙏

  • @noornaushad5743
    @noornaushad57432 жыл бұрын

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

  • @jemmy_is_happiness
    @jemmy_is_happiness Жыл бұрын

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

  • @Itzshiva238
    @Itzshiva2383 жыл бұрын

    Thank you sir...

  • @milanrai6987
    @milanrai69873 жыл бұрын

    Thank you sir 🙏

  • @anshulkumar733
    @anshulkumar7332 жыл бұрын

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

  • @Rsconfig
    @Rsconfig2 жыл бұрын

    Bahut achha apne samjhaya ek bar me sab samjh aaya

  • @vinayhasija250
    @vinayhasija2503 жыл бұрын

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

  • @gopalsharma-zu3yb
    @gopalsharma-zu3yb3 жыл бұрын

    Aaj tak ki ko thankyou nhi kha aaj dil kush hua thank you again boss

  • @AkashKumar-gr5mb
    @AkashKumar-gr5mb Жыл бұрын

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

  • @mdrajahasan6641
    @mdrajahasan66413 жыл бұрын

    Thank you sir ☺

  • @bushrafatima4397
    @bushrafatima43974 жыл бұрын

    Thank you so much Brother..

  • @shivanibhargav8921
    @shivanibhargav8921 Жыл бұрын

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

  • @mera950
    @mera9503 жыл бұрын

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

  • @meherunnisabegummeherunnis9797
    @meherunnisabegummeherunnis97972 жыл бұрын

    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

  • @navnitpandey5555
    @navnitpandey55553 жыл бұрын

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

  • @ratanbahadurpegha2216
    @ratanbahadurpegha22164 жыл бұрын

    Apka teaching method bahut achha laga,...koi tutors bahut jyada speed me boltey...tricks ki mouse speed kartey hai..to apka..best tutorial hai..tnx sir

  • @Sujatask-wh1ow
    @Sujatask-wh1ow2 жыл бұрын

    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

  • @kattimanirukmini1410
    @kattimanirukmini14103 жыл бұрын

    And happy teacher's day

  • @Amandeep-sb5sc
    @Amandeep-sb5sc3 жыл бұрын

    (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 ♥️🙏

  • @SurekhaKumari-fz5sb
    @SurekhaKumari-fz5sb9 ай бұрын

    Sir ap bahot hi acche se samaghaye ho🙏

  • @jitendrasaini178
    @jitendrasaini1782 жыл бұрын

    Bahut hi aasaani se samjhate ho sir aap

  • @juranmezka8631
    @juranmezka86313 жыл бұрын

    Thank u sir... Sir how to do then Percentage/Mean/SD

  • @surajshendeshende5232

    @surajshendeshende5232

    3 жыл бұрын

    Hi

  • @surajmanjarekar7263
    @surajmanjarekar726310 ай бұрын

    mast yaar....maza aaya...

  • @toseefadil681
    @toseefadil6813 жыл бұрын

    Sir im very impressed its good collection

  • @sabbirindia5106
    @sabbirindia51065 жыл бұрын

    Ishan bhai main Assam ka rehnewalahu... Aapki computer center SE Mujhe kese diploma milega.... Plz reply

  • @ishanguruofficial

    @ishanguruofficial

    5 жыл бұрын

    Han bilkul kar sakte ho. Academy ko call ya sms kr dena

  • @stylemax3252
    @stylemax32522 жыл бұрын

    Aap ke videos bahut ache hote hai...

  • @chanchal9970
    @chanchal99703 жыл бұрын

    Thank you sir you are may first computer tichar

  • @poojatandan3525
    @poojatandan35252 жыл бұрын

    Very helpful for learners thank you 😊

  • @samadhanvitthalsurwade3738
    @samadhanvitthalsurwade3738 Жыл бұрын

    बहुत बढ़िया तरीका है सर! मैं कई दिनों से इस प्रकार आसान तरीके की खोज में था। धन्यवाद।

  • @manojkumarmanojkumar8800
    @manojkumarmanojkumar88002 жыл бұрын

    Bahut achha lagraha bhaiya appki padhaneka tarika thank you so much

  • @adityamishrarishi7983
    @adityamishrarishi7983 Жыл бұрын

    Aap acha sikhate h, bahar paise laker itna koi nahi sikhata sir 🙏🌹💐😊

  • @princearjunkumar7635
    @princearjunkumar76352 жыл бұрын

    Sir aap ke sekhnay ka tarika bhoot acha ha❤️❤️

  • @devkahar3009
    @devkahar3009 Жыл бұрын

    Bahut badhiya sir..

  • @kamildahri3984
    @kamildahri39842 жыл бұрын

    Sir you are best teacher and best lecture

  • @sushmaraikwar3429
    @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 🙏🙏🙏🙏🙏🙏🙏

  • @kashishmaurya5198
    @kashishmaurya51982 ай бұрын

    Sir, your explanation is awesome

  • @mdsanaullah8360
    @mdsanaullah8360 Жыл бұрын

    Sir aap ka video bhut acha lage aise hi video dalte raheye plz taki hum log aage aur mukaam tak pahuch sake

  • @ashishmehra1361
    @ashishmehra13612 жыл бұрын

    Thank you so much sir ki apne bahut hi achhe tarike se bataya h.

Келесі