Here, we will learn how to use the Excel statistical functions: COUNT, COUNTIF and COUNTIFS.
COUNT function
The Excel COUNT function returns a count of values that are numbers. The function can be found in all the versions of Excel. COUNT takes the arguments like this: (value1, [value2], ...), of which value1 is a required argument and thereafter subsequent optional value arguments.
COUNTIF function
The Excel COUNTIF function returns the count of cells in a range that meet a single condition. The function can be found in all the versions of Excel. COUNTIF takes the arguments like this: (range, criteria), all of which are required.
COUNTIFS function
The Excel COUNTIFS function returns the count of cells in a range that meet multiple conditions. The function can be found in all the versions of Excel. COUNTIFS takes the arguments like this: (range1, criteria1, [range2], [criteria2], ...), of which the first pair of range and criteria is required and thereafter subsequent optional pair of range and criteria arguments.
You have successfully learnt how to use the Excel statistical functions: COUNT, COUNTIF and COUNTIFS.
