Question

Locked

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.

1 total post (Page 1 of 1)  
| 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:

=SUM(LEFT(A1,1)+RIGHT(A1,1))

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums