Excel Forum
Similar Content
Stop Formula Calculation in Excel - Increase Worksheet Performance
Tutorial: I'll show you how to stop formulas and functions from performing their calculations and u...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...

Excel Magic Trick 313: Some Facts About Array Formulas

Learn theses important Facts about Array Formulas:
Point #1: Formulas that do operations on ranges/arrays (A1:A4*B1:B4, instead of A1*B1) or functions that are expecting a single cell but you give it an array (LARGE(A1:A10,F25:F27) instead of LARGE(A1:A10, F27)) are ARRAY formulas.
Point #2: You tell Excel that you have an array formula by the key strokes Ctrl + Shift + Enter. If you do not use these keys, Excel will not know it is an array formula
Point #3: SUMPRODUCT and LOOKUP are examples of functions that can handle arrays without Ctrl + Shift + Enter, so they are not array formulas.

Related Videos:
06 Excel Series: Array Formulas
Excel Array Formula Series #1: Basics of Array Formulas
Excel Array Formula Series #7: Boolean Logic & Criteria
07 Excel Formula Efficiency Series
Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples

Got a Question? Ask it Here in the Forum.