Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...

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.