How to Use SUMIFS and COUNTIFS || MS Excel Malayalam

In this video we can learn how to use sumifs and countifs function in excel Malayalam with example and explanation by comparing with sumif and countif. These both functions are introduced in Excel 2007, and so is not available in earlier versions of Excel.
Very often people get confused between countif and countifs as well as sumif and sumifs function, as they both seem to be alike and the purpose of using them is also same. The only difference between these two functions is
• Countif or sumif is used when you want to count cells based on single condition and in single range.
• Countifs or sumifs is used to count cells based on multiple conditions in multiple ranges.
#SumifsFunctionMalayalam #CountifsFunctionMalayalam #ExcelMalayalam
• 10 Magical Time Saving Tips & Tricks To Make You Excel Expert : • 10 Magical Tricks in M...
• Learn Basic VLOOKUP Function in 5 Minutes : • Learn Basic VLOOKUP in...
• How to Use SUBTOTAL Function in MS Excel : • How to Use SUBTOTAL Fu...
• 5 Easy Method to Find & Remove Duplicate Data in Excel : • Find & Remove Duplicat...
• How to Create a Pivot Table in Excel : • Learn Pivot Table in 1...
• Excel IF Function | IF, SUMIF, COUNTIF, NESTED IF : • IF, SUMIF, COUNTIF, NE...
• 12 Functions in 12 Minutes || Excel Text Functions : • Data Cleaning Function...
• MIND-BLOWING Excel Trick | Auto Advanced Filter - • How do I use advanced ...
• Difference Between VLOOKUP vs HLOOKUP - • What is VLOOKUP vs HLO...
• How to Insert Blank Rows & Columns After Every Data in Excel : • How to Insert Blank Ro...
• 12 Coolest Shortcut Keys to Accelerate Your Work - • Top Excel Keyboard Sho...
• This Pivot Table Trick Will Blow Your Mind - • This Pivot Table Trick...
• How To Repeat Headings on Each Page - • How To Repeat Headings...
• How to build a SEARCH BOX in Excel without VBA - • How to build a SEARCH ...
• Stock Management System in Excel - • Stock Management in Ex...
Sumifs malayalam,countif multiple criteria Malayalam ,sumifs example,how to use sumifs,count if less than,excel sumif,sumifs greater than,sumifs multiple criteria,sumifs smaller than,sumif,countifs,averageifs,sumifs formula,advanced excel Malayalam ,learn excel formulas,excel formulas,excel tips,excel tips and tricks Malayalam ,best excel online course Malayalam ,excel advanced formulas,improve excel skills Malayalam ,skills to succeed by alfan,excel for analysts,excel for controllers,microsoft excel expert, mohammed alfan, countifs Malayalam, excel Malayalam tutorial
Let’s connect on social:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan
Sumifs malayalam,countif multiple criteria Malayalam ,sumifs example,how to use sumifs,count if less than,excel sumif,sumifs greater than,sumifs multiple criteria,sumifs smaller than,sumif,countifs,averageifs,sumifs formula,advanced excel Malayalam ,learn excel formulas,excel formulas,excel tips,excel tips and tricks Malayalam ,best excel online course Malayalam ,excel advanced formulas,improve excel skills Malayalam ,skills to succeed by alfan,excel for analysts,excel for controllers,microsoft excel expert, mohammed alfan, countifs Malayalam, excel Malayalam tutorial

Пікірлер: 74

  • @rows_columns
    @rows_columns2 жыл бұрын

    📌To Learn Microsoft Excel in English, Click on the Below Link: kzread.info/dash/bejne/daJnj8SFdM6tfbw.html

  • @ashirbabu7242

    @ashirbabu7242

    Жыл бұрын

    Perfect ❤️

  • @Faiztv-m2z
    @Faiztv-m2z4 жыл бұрын

    സൂപ്പർ ക്ലാസ് ആയിരുന്നു.

  • @unaispallath7512
    @unaispallath75123 жыл бұрын

    very help full bro

  • @mkshameem5237
    @mkshameem52373 жыл бұрын

    Super ❤️

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

    Very helpful 👍

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

    Perfect teaching ❤️

  • @vishnusoman8532
    @vishnusoman85322 жыл бұрын

    Sumifs and Countifs are very useful and easy to use, Thanks!

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Vishnu😊

  • @ajiabraham1206
    @ajiabraham12063 жыл бұрын

    Thank you

  • @bijuiypemathew1338
    @bijuiypemathew13383 жыл бұрын

    Thank you,nicely explained

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    😊

  • @zain-rd8fu
    @zain-rd8fu2 жыл бұрын

    Very useful🔥🔥

  • @saheedop421
    @saheedop4212 жыл бұрын

    This is very useful for me in my day to day tasks at office. Thank you 🙏

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊

  • @ahmedrifayi8257
    @ahmedrifayi82573 жыл бұрын

    Thanks bro

  • @swathichandran1107
    @swathichandran11073 ай бұрын

    Nyc presentation sir

  • @jijeeshpadmanabhan350
    @jijeeshpadmanabhan3503 жыл бұрын

    Well explained. Thank you

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    Glad it was helpful!

  • @aneesmv5243
    @aneesmv52432 жыл бұрын

    Presentation is very nice, easy to catch, thank You bro 👍

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Welcome 👍

  • @vipinkv2050
    @vipinkv20504 жыл бұрын

    Very well explained 👌

  • @rows_columns

    @rows_columns

    4 жыл бұрын

    🤝😊

  • @user-fv7qf8ex4g
    @user-fv7qf8ex4g2 күн бұрын

    1 ൽ അധികമുള്ള സെല്ലിനെ ആണോ criteria range എന്നും ...... ഒറ്റ സെല്ലിനെ criteria 1, criteria 2 etc എന്നും ആണോ ? Any way nice Tutorial

  • @abdullahvayalar
    @abdullahvayalar3 жыл бұрын

    VERY VERY GOOD

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    Many many thanks

  • @shibilsnoopy3973
    @shibilsnoopy39734 жыл бұрын

    Nice

  • @shafeer_wayanad
    @shafeer_wayanad2 жыл бұрын

    Good information dear

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates

  • @imagedsignstudio9652
    @imagedsignstudio96524 жыл бұрын

    Be the first for ever 😎

  • @pranavprabhakaran1630
    @pranavprabhakaran16303 жыл бұрын

    Thank you...

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    😊

  • @vishnums6873
    @vishnums68732 ай бұрын

    very useful class

  • @rows_columns

    @rows_columns

    Ай бұрын

    Glad to hear that

  • @zakariyakk6244
    @zakariyakk624424 күн бұрын

    Super❤

  • @rows_columns

    @rows_columns

    21 күн бұрын

    Thanks 🔥

  • @mujeebrehman849
    @mujeebrehman8492 жыл бұрын

    Hi... What is the best way for Unique count?

  • @youtubeismyguide1281
    @youtubeismyguide12814 жыл бұрын

    Adipoli

  • @rows_columns

    @rows_columns

    4 жыл бұрын

    😊

  • @viswanathancr2801
    @viswanathancr28013 жыл бұрын

    good video

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    Thanks

  • @bashiblues6297
    @bashiblues62973 жыл бұрын

    goood info

  • @MrSunilun
    @MrSunilun2 жыл бұрын

    Super

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊

  • @letslearntogether1117
    @letslearntogether11172 жыл бұрын

    sumifs and countifs engane cheith nokiyitum 0 anu output kittunne pls help

  • @todaystrending4339
    @todaystrending43392 жыл бұрын

    Hi bro, very useful session. What is the formula to find the sum of a value greater than a certain amount and less than a certain amount.??

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    kzread.info/dash/bejne/eYasq7KuctKqZJc.html

  • @3Angelsin3AnglesMRF
    @3Angelsin3AnglesMRF2 жыл бұрын

    സൂപ്പർ class 🥰👍🏻

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thank you😊

  • @ananduhari5859
    @ananduhari5859Ай бұрын

    Criteria namku text pakaram number use chiyavo

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

    please help me to get the worksheet

  • @sajeerkakkarayil7256
    @sajeerkakkarayil72562 жыл бұрын

    Name range vech oru vedio cheyyu

  • @ahmadnaha8119
    @ahmadnaha81192 жыл бұрын

    I HAVE DRIVERS AROUND 100 AND EACH HAVE TRIP WITH DIFRRENT DESTINATION HOW CAN SHOW IN ONE PAGE WITH LIST OF DESTINATION

  • @anascc7353
    @anascc73537 ай бұрын

    ✌🏻

  • @bijubpillai9164
    @bijubpillai91643 жыл бұрын

    ഞാൻ താങ്കളെ follow ചെയ്യുന്ന ഒരാളാണ്.. ഒരു exel work sheet ൽ നമ്മൾ ഒരു 1000 Components ന്റെ Dimension range കൊടുത്തു അതിൽ നിന്നും നമ്മൾ തെറ്റായി type ചെയ്യുന്ന range values എങ്ങനെ കണ്ടെത്താൻ ആകും...ഉദാഹരണത്തിന് correct range 31മുതൽ 35 വരെ ആണന്നു വയ്ക്കുക ഞാൻ 1000components ന്റെ range exel ൽ type ചെയ്തു ഇതിൽ നിന്നും ഞാൻ തെറ്റായി type ചെയ്തത് എങ്ങനെ പെട്ടന്ന് കണ്ടെത്താൻ ആകും.. അതുനുള്ള formula എന്താണ് ഒന്ന് പറഞ്ഞു തരാമോ please...

  • @rows_columns

    @rows_columns

    3 жыл бұрын

    Give me ur WhatsApp no… let’s discuss😊

  • @smysuhailkhan
    @smysuhailkhan3 жыл бұрын

    ഒരു ചെറിയ ഡൌട്ട്. ഞാൻ എനിക്ക് ഒരു പേർസണൽ ഡെയിലി സെയിൽസ് ടാർഗറ്റ് ഷീറ്റ് ഉണ്ടാകുന്നു ഫോർ a മന്ത് ആദ്യത്തെ കോളം ഡേറ്റ് രണ്ടാമത്തെ കോളം ഡെയിലി ടാർഗറ്റ് എമൗണ്ട് തേർഡ് കോളം ഡെയിലി സെയിൽസ് വാല്യൂ For example day one my taget 3000 my sales 2000 Athe pole eniku ella divasavum 3000 target aanu chiladivasam njan sales value kuravayirikum chilapol kooduthal aayirikum Angane varumbol ente sales value depend cheythu next day target either balance value add or substract aakanm until month end. Can teach me how. Plz?

  • @jessyshajan682
    @jessyshajan6822 жыл бұрын

    🤗

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates

  • @shamal.k1531
    @shamal.k15312 жыл бұрын

    👍🏻👍🏻, date criteria vekkumbol error varunn😐

  • @ShafeekkootteeriSk-gg9vx
    @ShafeekkootteeriSk-gg9vx Жыл бұрын

    Ithill oru person answer kandind drag chyan Patoola alle 😂?😢😢😢😢 sadikumnkill answer

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

    Hai njan oru subsriber anu excel nallapoley ariyilla pala formulayilum * , ? E symbolukal upayogikunnath kandu enthan ithinte meaning, ivide "AJ*" INGAey ittu e * nte meaning enthanu

  • @ajeeshabu7724
    @ajeeshabu77246 ай бұрын

    Nice