COUNTIFS

COUNTIFS(arg1, arg2, arg3, arg4) → { number }

Counts a number of cells specified by a given set of conditions or criteria.

Parameters:

Name Type Description
arg1 ApiRange

The first range of cells to count nonblank cells.

arg2 number | string

The first condition in the form of a number, expression, or text that defines which cells will be counted.

arg3 ApiRange

Up to 127 additional ranges of cells to count nonblank cells. This argument is optional.

arg4 number | string

Up to 127 additional conditions in the form of a number, expression, or text that define which cells will be counted.

Returns:

Type
number