I have learned how to use both a sumproduct formula and an array formula to both "count" and "sum" based on multiple criteria.

However my question to all of you is, what advantage does an array have over sumproduct and vice versa.

Personally i don't see why you wouldn't use sumproduct in place of ANY array.

Thanks