Conditional Counting


alt text

COUNTIF


alt text

COUNTIFS

For more information, refer to the COUNTIFS Function page.

alt text

SUMPRODUCT

For more information, refer to the SUMPRODUCT Function page.

alt text

{SUM}

For more information, refer to the Array Formulas page.

alt text

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


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext