110. Using SUMIF for conditional summing

Using COUNTIF for Conditional Counting

The **COUNTIF** function in Excel is used to count the number of cells in a range that meet a specific condition (criteria). It is ideal for data analysis, allowing users to quickly filter and count data based on defined conditions.

Syntax of the COUNTIF Function

=COUNTIF(range, criteria)
    
  • range: The range of cells to evaluate.
  • criteria: The condition to count cells (e.g., "<50", ">100", "=85").

Steps to Use the COUNTIF Function

  1. Select the cell where you want the result to appear.
  2. Type =COUNTIF( followed by the range and condition.
  3. Close the parentheses ) and press Enter to see the result.

Interactive Example: COUNTIF Function

Item Value
Entry 1 85
Entry 2 90
Entry 3 75
Entry 4 60
Criteria >80
Count of Matching Values Click Calculate

Edit the values and criteria in the table above, then click "Calculate Count" to see the COUNTIF function in action.

This example demonstrates how the COUNTIF function evaluates a range of cells against a condition to calculate the count of matching values.

Comments