Conditional Counting

COUNTIF

COUNTIFS

For more information, refer to the COUNTIFS Function page.

SUMPRODUCT

For more information, refer to the SUMPRODUCT Function page.

{SUM}

For more information, refer to the Array Formulas page.

Important

You cannot use the AND and OR functions in array formulas directly because those functions return a single result (not an array of results).