The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as …

Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.

Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.

Formulas that can return arrays of variable size are called dynamic array formulas. Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array …

Use array constants in array formulas or by themselves to save time, and when you need values that aren't in your workbook.

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

To change or edit an array formula, you need to follow some rules, especially if you have multi-cell formulas. This article spells out the rules.

Learn how to use the spilled range operator to return a spilled array range in its entirety.

You've created this great array formula, but now you need to add a dozen rows of data, and you're finding you can't just add that data to your formula. Here's what you need to do.

To resolve it, try rewriting your formula. If you have a nested formula, you can try using the Evaluate Formula tool to identify where the #CALC! error is occurring in your formula.