How to use countifs formula in excel in hindi HD

TeachToEach presents a wonderful video “how to use countifs formula in excel in hindi”. This Excel tutorial explains you how to use countifs function in excel 2013 with syntax and examples. What CountIFS function does-This formula gives total count where multiples criteria matched.Lets I explain you Countifs formula in excel 2013,2013,2007 in hindi Syntax of excel Countifs function in excel 2010:- =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) Criteria_range1 = select range where the critera1 is available. Range1 = select the condition number1 Criteria_range2 = select range where the critera2 is available Range2 = select the condition number2 and so on We can put only 127 ranges in this formula. You will facing a problem to understand CountIFS data range formula in 2007 if you are not know how to use CounIF formula. So I recommend first, you should to learn CountIF function in excel. You can learn CountIf formula in excel 2013 by going this link https://www.youtube.com/watch?v=yw793miJQDc. Countifs works with multiple criteria The countifs function in excel 2007 is working same as its working with excel 2003. It is a very difficult task to anyone. If you are really interested to learn this trick then this video of excel countifs function tutorial never lets you down. Thanks for watching this video. It is humble request to you please subscribe my Channel www.youtube.com/teachtoeach. I will definitely create more videos about tips and tricks to excel. Some popular videos-: 1) How to use sumproduct formula in excel -https://www.youtube.com/watch?v=Ut6myeS5akU 2) How to protect excel sheet in hindi - https://www.youtube.com/watch?v=6ltqeNyOJJQ 3) Relative Absolute and Mixed Cell Referencing in Excel -https://www.youtube.com/watch?v=R3GEbagnbp4 4) Excel Logical Functions IF AND OR NESTED IF in Hindi - https://www.youtube.com/watch?v=Us1wr2QrrlM 5) Reverse Lookup Formula Vlookup with Choose Function in Excel - https://www.youtube.com/watch?v=n8rcnbOrFYY 6) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel - https://www.youtube.com/watch?v=Rl20i2YoEjI 7) How to consolidate multiple worksheets into Pivot Table - https://www.youtube.com/watch?v=OGa6EKTFb5s 8) How to use Vlookup formula in Excel 2013 Hindi By TeachToEach - https://www.youtube.com/watch?v=g_mdM26krgA 9) Mail Merge in Word - https://www.youtube.com/watch?v=1xuTbaHSYRQ 10) How to Find and Remove Duplicates in Excel 2013 in Hindi By TeachToEach - https://www.youtube.com/watch?v=RxEa6Yck2fg