Microsoft Office Tutorials and References

In Depth Information

**Calculating Multiple Results**

Calculating Multiple Results

An array formula can perform multiple calculations and then return either a single or mul-

tiple 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 formu-

las 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

Click the cell where you want to enter the array formula.

Click the
Formulas
tab.

Type
=
(an equal sign).