Excel® 2013 On Demand

Calculating Multiple Results

An array formula can perform multiple calculations and then return either a single or multiple result. For example, when you want to count the number of distinct entries in a range, you can use an array formula, such as {=SUM(1/COUNTIF(range,range))}. You can also use an array formula to perform a two column lookup using the LOOKUP function. An array formula works on two or more sets of values, known as array arguments. Each argument must have the same number of rows and columns. You can create array formulas in the same way that you create other formulas, except you press Ctrl+Shift+Enter to enter the formula. When you enter an array formula, Excel inserts the formula between { } (brackets).

Create an Array Formula ...