COUNTIFS

Counts values based on multiple conditions

COUNTIFS( column, criteria,[ additional_column, additional_criteria,...])

Counts the values in a column that are within a row meeting all specified criteria; multiple column, criteria pairs can be input.

Arguments

Argument	Description
column	Column to count
criteria	Condition that must be met for column to be counted. May reference the same or different column than column
additional_column	Additional column to count
additional_criteria	Condition that must be met for additional_column to be counted. May reference the same or different column than additional_column

Outputs

Outputs count of values in column(s) that meet all criteria

Example

With this formula:

COUNTIFS({Adult Population}, {Child Population} < 1000000, {Adult Population}, {Region}="East")

We see the resulting table. Criteria are applied to {Region}and {Child Population}, while {Adult Population} is being counted.