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:
COUNT() Syntax
Download: PDF Notes Excel File
The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.
Syntax:
=COUNT(value1,[value2],...)Parameter:
• value1 - An item, cell refernce, or range
• [value2],... - (Optional) An item, cell refernce, or range
Example 1:
=COUNT(20,7)
Output: 13
Example 2:
=COUNT(A1:C1)
Output: 12
COUNTA() Syntax
the COUNTA function counts the number of cells that are not empty in range.
Syntax:
=COUNTA(value1,[value2],...)Parameter:
• value1 - The first argument representing the values that you want to count
• [value2],... - (Optional) Additional arguments representing the values that you want to count.
Example 1:
=COUNT(10,5)
Output: 2
Example 2:
=COUNTA(A1:D1)
Output: 3
COUNTBLANK() Syntax
to count the numer of empty cells in a range of cells.
Syntax:
=COUNTBLANK(range)Parameter:
• range - The range from which you want to count the blank cells.
Example 1:
