## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# Chapter 72. Array Formulas and Functions

• What is an array formula?

• How do we interpret formulas such as (D2:D7)*(E2:E7) and SUM(D2:D7*E2:E7)?

• I have a list of names in a single column. These names change often. Is there any easy way to transpose the listed names to a single row so that changes in the original column of names are reflected in the new row of names?

• I have a list of monthly stock returns. Is there a way to determine the number of returns between -30 percent and -20 percent, -10 percent and 0 percent, and so on that will automatically update if I change the original data?

• Can I write a single formula that will sum up the second digit of a list of integers?

• Is there a way to look at two lists of names and determine which names occur on ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required