Conditional Counting

COUNTIF

COUNTIFS

SUMPRODUCT

{COUNT}

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).