Microsoft Excel Functions & Formulas

Use the MID function to sum the digits

of a number

A worksheet contains four-digit numbers in column A. Each of the

four digits has to be added and the result shown in column B. To do

so, the four digits of a cell are extracted by the MID function and

summed.

4

To determine the cross sum:

1. In a worksheet, enter a series of four-digit numbers in cells

A2:A10.

2. Select cells B2:B10 and type the following formula:

=MID(A2,1,1)+MID(A2,2,1)+MID(A2,3,1)+MID(A2,

4,1).

3. Press <Ctrl+Enter>.

Text Functions 63

3

Figure 3-5