|
|
Featured Tutorial
Featured Macro
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.
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.