Countif With VBA Code in Excel Hindi - Learn VBA in Hindi HD

26.07.2019
Learn VBA Macro and use Countif formula with vba code. Download Practice Files from http://wp.me/p7DKaP-1fz in this Excel VBA Tutorial you will vba code for Countif formula we will calculate the present and absent values using VBA This VBA tutorial shows you how to create a simple Excel VBA Macro to calculate the count of Present and Absent values using Countif formula The VBA code for Countif formula is Dim Present As Integer Dim Absent As Integer Present = Application.WorksheetFunction.CountIf(Range("b4:i4"), "p") Absent = Application.WorksheetFunction.CountIf(Range("b4:i4"), "a") Range("j4") = Present Range("k4") = Absent ** Useful Excel formulas and Functions ** 10 Most Used Formulas MS Excel-https://youtu.be/KyMj8HEBNAk Learn Basic Excel Skills For Beginners- https://youtu.be/3kNEv3s8TuA Learn the Basic of Excel for Beginners -https://youtu.be/qeMSV9T1PoI 10 Most Used Excel Formula-https://youtu.be/2t3FDi98GBk Learn Vlookup Formula For Beginners in Excel-https://youtu.be/vomClevScJQ 5 Excel Questions Asked in Job Interviews-https://youtu.be/7Iwx4AMdij8 Create Speedometer Chart In Excel-https://youtu.be/f6c93-fQlCs Create Pareto Chart In Excel-https://youtu.be/2UdajrDMjRE How to Create Dashboard in Excel-https://youtu.be/RM8T1eYBjQY Excel Interview Questions & Answers-https://youtu.be/Zjv1If63nGU To watch more videos and download the files visit http://www.myelesson.org To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788 Connect with us on Facebook - https://www.facebook.com/excelmadeasy/ Connect with us on Twitter - https://twitter.com/Excelmadeasy

Похожие видео

Показать еще