I'd strongly advise use of Product column and SUMIFS if working with large precedent ranges.

If you need to return multiple combinations you might consider using a Pivot Table.