COUNTIF

Counts values based on a condition

COUNTIF( column, criteria )

Counts the values in a column that are within a row meeting the specified criteria

Arguments

Input	Description
column	Column to count
criteria	Condition that must be met for values within column to be counted. criteria may reference the same or different column as column .

Output

Outputs count of values in column that meet criteria

Example

In this example, there are two rows with {Child Population}<1000000 , but becauseCOUNTIF is aggregating {Adult population}, a null value decreases the count by 1.