excel sum formular

By manny_coker ·
is there anyway i could sum up 2 digits in 1 cell for example cell A1 contains "15" how can i sum "15"=6 all to 1 cell

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

re sum formula

by ThumbsUp2 In reply to excel sum formular

For a two digit number, the following formula will add the digits together:


If the cell A1 contains the number 15, the cell the formula is placed in will contain 6 (ie, that's 1 + 5).

For more digits in cell A1, you'll have to get more creative and use the MID function.

Related Discussions

Related Forums