How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi ?
In this basic tutorial of beginners, you will learn how to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formulas.
COUNT formula is used to count numeric values in selected rows or columns and COUNTA formula can count both albhabates and numbers in selected cells or columns. COUNTBLANK formula counts the blank cells in selected database. COUNTIF formula is used to count cells in a range that meets a particualr criteria. COUNTIFS formula counts the number of cells in a range that meets single or multiple criteria.
======================================
What is covered in this video:
1. how to use all count formula in excel
2. how to use count formula in excel
3. how to use counta formula in excel
4. how to use countblank formula in excel
5. how to use countif formula in excel
6. how to use countifs formula in excel
======================================
Download Exercise File: https://drive.google.com/file/d/1NUKubaODZpOaKSQ7J5jg0C_9c8c5eQY-/view?usp=sharing
Our other videos:
1. Title: How to make a Beautiful Excel Column Chart or Graph for Target vs Achievement in Hindi
https://youtu.be/Ir_ELM4mifg
2. Title: KPI Progress Circle Chrats in Excel (Hindi) by PowerEx by Jitendra
https://youtu.be/Yo4H4MYprGA
3. Title: Multiple Pivot Tables and Slicers in Excel in Hindi by PowerEx by Jitendra
https://youtu.be/ThFBW0nnUN4
4. Title: Uses of Dollar Sign ($) in Excel | Absolute, Relative and Mixed References | Fixing Formulas (Hindi)
https://youtu.be/TruaQkxiwCY
5. How To Create Auto Updating Drop Down List In Excel Hindi | Dynamic Drop Down List | Data Validation
https://youtu.be/YQEGlaghtBI
6. How to use Data Validation in Excel in Hindi | Detailed Explanation of MS Excel - Data Validation
https://youtu.be/TANc_RBDCUo
7.Dependent Drop Down List in Excel | Creating MS Excel - Dependent Drop Down List in Hindi
https://youtu.be/fl45gE2YWXQ
8.How to Make an Impressive MS Excel - Column Chart Graph Showing Percentage | Target vs Actual -Hindi
https://youtu.be/tgOavfn-dOc
9.Hide and Unhide Horizontal and Vertical Scroll Bars|Sheet Tabs|Headings Gridlines Formula Bar Ribbon
https://youtu.be/fD8tTrjZiRY
10. How to Create a Quick and Simple Excel Chart with just One Click and Excel Chart Formatting Tutorial
https://youtu.be/lf_WJGUCoWA
11. 12 Useful Excel Pivot Table Tips and Tricks everyone should know | Advance Pivot Table Tips in Hindi
https://youtu.be/Of9w-Y-7cRM
12.Vlookup Formula in MS Excel with Examples| Finding Particular Data in Same/Different Workbooks Hindi
https://youtu.be/I_33jLRvqmQ
13. How to Get Multiple Results by Using Vlookup Formula with Columns Formula in MS - Excel in Hindi
https://youtu.be/Kf9u4jFcfC8
14. How to Use Vlookup with Match Function in Excel | Two Dimensional Vlookup in MS Excel (Hindi)
https://youtu.be/54mWSjpZNdg
15. Using Hlookup Formula in MS Excel in Hindi Hlookup and Columns Function Explained With Examples
https://youtu.be/vWqNUivor1s
Video is created by Jitendra in MS Excel 2010.
Published on Powerex by Jitendra
#countfunctions
#powerexbyjitendra
#excel
Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7
Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.