Add up all Numbers in a Cell with a Line Break?

[Willy Excel]

Sum These	Place Here:
2 1	3
	0
1 2	3
2	2

<tbody>
</tbody>

Greetings! Is there a simple method to SUM all digits within a cell with line breaks?

Some cells in the column have no numbers, some have one number, and others have a line break with a number on top and number on bottom.

Or: is there a way to highlight the cells and show "Sum:" down bottom?

Thanks!<attachment></attachment>

 

[NoSparks]

A PC and the linefeed shows as chr(10) for me.

Have you tried the suggested solution from there?

 

[Willy Excel]

FormR, you are very savvy! Thanks. Looks like it's solved.

If you're curious, the other link at MSOfficerForums was:
Add up all Digits Within a Cell with a Line Break

 

[Willy Excel]

NoSparks, I haven't yet, but that raises an interesting point. Do you guys think if I access the excel spreadsheet on a PC after solving it with 13 instead of 10 in the formula, it will not work anymore?

 

[FormR]

If you're curious, the other link at MSOfficerForums was:
Add up all Digits Within a Cell with a Line Break

Glad to help

If you can spare a little time then this is worth a read:

https://www.excelguru.ca/content.php?184

 

[FormR]

Do you guys think if I access the excel spreadsheet on a PC after solving it with 13 instead of 10 in the formula, it will not work anymore?

I doubt very much that switching systems will alter the underlying values.

 

[Willy Excel]

I tested it on my work PC, and it did return an error message, but it was easily solved by changing the "13" back to "10." If there is any solution that would work on both Mac and PC, that would be terrific, although this is quite excellent (just have to do the 13/10 swap on that one column when switching between the Mac/PC). FormR, I read the link. My mistake on the multiple forum etiquette. Thanks for all the help.

 

[FormR]

have to do the 13/10 swap on that one column when switching between the Mac/PC)

Hi, you could give this a try:

=SUMPRODUCT(0+(0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,CHAR(10),CHAR(13)),CHAR(13),REPT(" ",99)),{1,2}*99-98,99))))

 

[Willy Excel]

Form R, sorry for the delayed return to the topic. Working on that project again a month later. No luck with that latest formula. Your previous one works perfectly, however. Much appreciated!

 

[Willy Excel]

The solution in this thread works and I won't need any more assistance.

Links to other cross posts (my mistake on forum etiquette):

Can't see how to edit first post, so links below:
https://www.excelforum.com/excel-fo...-sum-2-rows-of-digits-within-single-cell.html
Add up all Digits Within a Cell with a Line Break

 

[TonyUK72]

=IF(LEN(I2)>=2,SUM(LEFT(I2,1),RIGHT(I2,1),I2))

change I2 for the relevant cell then copy formula down