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