The COUNTIF formula in Excel | Video #5
This video will help you count a cell value in a data table that meets a single criteria by using COUNTIF Formula
COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. The COUNTIF function supports logical operators and wildcards for partial matching
The simple syntax of the Countif function is as follows
=COUNTIF(Where do you want to look?, What do you want to look for?)
=COUNTIF(Range,Criteria)
A note to remember in in the COUNTIF formula is that whenever under criteria you include a text values it need to be enclosed in double quotes, and numbers do not. However, when a logical operator is included with a number, the number and operator must be enclosed in quotes, as seen in the second example below
Other videos
INDEX and MATCH Functions - Explained Easy
• INDEX and MATCH Functions - Explained Easy...
TOP 5 Most Used Formulas In Excel
• TOP 5 Most Used Formulas In Excel | Video #12
How to change the text to Capital, Small and Proper letters in Excel
• How to change the case of text in Excel | ...
How to combine two or more text strings in Excel
• How to combine two text in Excel | Video #7
Remove all unwanted spaces from a text in Excel
• How to remove extra spaces from text in Ex...
Multiple logical test with AND & OR functions in excel
• AND & OR formulas in Excel | Video #4
Cell references - Relative and Absolute cell reference in Excel
• Data validations in Excel | Part I | Video #9
How to write an IF Function in Excel 2016
• IF formula in Excel | Video #3
Hope you have liked the video. Thank you for watching
Subscribe to my channel for more video updates:
/ @excelwithkumar
Excel Beginner to Intermediate within 60 minutes playlist:
• Getting started with Excel - The Beginners...
#MicrosoftExcel
#Countif
#ExcelwithKumar