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.

Category:

Science & Technology

Tags:

• Excel
• Add
• or
• Criteria
• SUM
• IF
• SUMPRODUCT
• function
• Array
• formula
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[denisrapp]

Dear excelisfun,

great video as always! thanks a lot!

I accidentally found out that to highlight a table in excel 2007 instead of CTRL *, you could use the famous CTRL A (when your active cell is inside of the table).

[ExcelIsFun]

Dear denisrapp,

EXCELlent!! Ctrl + A! Ctrl + *!

--excelisfun

[ExcelIsFun]

Dear amrorakay,

I am glad that you like it. I hope you and your team of Excelers take full advantage by downloading the workbooks and watching the videos!!

--excelisfun

[ExcelIsFun]

Dear cidfidoutube,

It is for you and for all our other Excelers at YouTube!!

With that kind of formula, you see why I think Excel Is Fun!

--excelisfun