Question Locked

excel sum formular

0 helpful

2 replies

by manny_coker Feb 1, 2008 last reply Feb 1, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

Clarifications

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.

This discussion is closed to new replies.