Microsoft Excel Functions & Formulas

Use the SUM and LEN functions to count all

digits in a range

With what you have learned so far about array formulas, this task

should be easy. Here we will count all digits in the range A1:A10

and display the result in cell C2. As you have probably already

guessed, both the SUM and LEN functions can be combined in an

array formula.

4

To count all digits in a range:

1. In cells A2:A10 type any text.

2. Select cell C2 and type the following array formula:

=SUM(LEN(A1:A10)).

3. Press <Ctrl+Shift+Enter>.

Working with Array Formulas 295

11

Figure 11-17