Microsoft Excel Basic Syntax:
INTRO BONUS CLASS SYNTAX EXPLAIN SUM AVERAGE MAX MIN IF SUMIF AVERAGEIF COUNT | COUNTA | COUNTBLANK COUNTIF Excel ShortCut Keys
PART 1:
PART 2:
COUNTIF() Syntax
Download: PDF Notes Excel File
the COUNTIF function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, test that match specific criteria(condition).
Syntax:
COUNTIF(range,criteria)Parameter:
• range - The range of cells to count
• criteria(condition) - The criteria(condition) which cells should be counted
Example 1:

=COUNTIF(B1:B6,"Neha")
Output: 2
Example 2:

=COUNTIF(B1:B6,">2000")
Output: 1
Example 3:

=COUNTIF(A1:A6,"<2000")
Output: 3
Example 3:
