Microsoft Office Tutorials and References

In Depth Information

**Using Arrays in Formulas**

However, getting the braces into the formula takes a particular keystroke.

You don’t type braces in directly.

Using Arrays in Formulas

You can use arrays when entering formulas and functions. Typically, the

arguments to a function are entered in a different manner, which I

demonstrate in this section. Using arrays can save entry steps and deliver an

answer in a single formula. This is useful in situations that normally require

a set of intermediate calculations from which the final result is calculated. I

don’t know about you, but I like shortcuts, especially when I have too much

to do!

Here’s an example: The SUM function is normally used to add a few numbers

together. Summing up a few numbers doesn’t require an array formula per

se, but what about summing up the results of other calculations? This next

example shows how using an array simplifies getting to the final result.

Figure 3-2 shows a small portfolio of stocks. Column A has the stock symbols,

Column B has the number of shares per stock, and Column C has a recent

price for each stock.

Figure 3-2:

A stock

portfolio.

The task is to find out the
total
value of the portfolio. The typical way to do

this is to

1. Multiply the number of shares for each stock by its price.

2. Sum up the results from Step 1.