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).
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited