Excel Forum

Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria

Amazing Array Formula that allows 3 or 2 criteria into an array formula based on a drop down arrow cell results.
See Boolean Logic Math work inside the SUM function with an IF function that decides whether the formula should look at 2 two criteria or 3 three.
Also, see an important array formula trick that will not work with SUMPRODUCT (unless you use Ctrl + Shift + Enter). See that in this case SUM will be shorter than SUMPRODUCT.

Got a Question? Ask it Here in the Forum.