excel An array formula example

An array formula enables you to perform individual operations on each cell in a range in much
the same way that a programming language’s looping feature enables you to work with elements
of an array. If you’ve never used array formulas before, this section will get your feet wet with a
hands-on example.
Figure 3-6 shows a worksheet with text in A1:A5. The goal of this exercise is to create a single
formula that returns the sum of the total number of characters in the range. Without the single
formula requirement, you’d write a formula with the LEN function, copy it down the column, and
then use the SUM function to add the results of the intermediate formulas.