The COUNTIF function counts the number of cells in a range that meet a given criteria. This function is useful when determining the repeat occurrence of data or data within a specified range. The COUNTIF function is defined as:
= COUNTIF( range, criteria)
The inputs are defined as:
range – the range of cells to be counted based on the criteria,
criteria – the criteria used to determine which cells to count.
In this tutorial the COUNTIF function is used to count the number of times the selected range exceeds the Monthly Sales Goal.
The COUNTIF functions is defined by the following inputs.
range – The range is the total sales value for the 6 months displayed in Table 1.
criteria – The criteria is all cells greater than the Monthly Sales Goal (Cell C8). The syntax for this criteria is “>”&C8.
The COUNTIF function counts the number of monthly Total Sales that are greater then the value of $11,000 and determines 6 times.