USE THE MID FUNCTION TO SUM THE DIGITS OF A NUMBER USING MICROSOFT EXCEL

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.

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->.

USE THE MID FUNCTION TO SUM THE DIGITS OF A NUMBER USING MICROSOFT EXCEL