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 TopPrevNext