Table of Contents

1. Formula Basics
2. Introduction to Array Formulas
3. Math Array Operations
4. Comparative Array Operations and Aggregate Calculations with One or More Conditions
5. Join Array Operations
6. Function Argument Array Operations
7. Array Constants
8. Array Formulas That Deliver More Than One Value
9. A First Look at Array Functions: TRANSPOSE, MODE.MULT, and TREND
10. The Amazing SUMPRODUCT Function (and SUMIFS, Too)
11. Boolean Logic: AND Criteria and OR Criteria
12. When Is an Array Formula Really Needed?
13. Dynamic Ranges with the INDEX and OFFSET Functions
14. Array Formula Efficiency Rules
15. Extracting Data, Based on Criteria
16. The FREQUENCY Array Function
17. Unique Counting Formulas and the Power of the FREQUENCY Function
18. The MMULT Array Function
19. Extracting Unique Lists and Sorting Formulas
20. Conditional Formatting with Array Formulas
21. Data Tables
22. The LINEST Array Function
23. Can You Figure Out How the Huge Array Formula Works?
24. Three Bonus Examples