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

Top

PrevNext