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).
Search JabSto ::

Custom Search