Microsoft Office Forums Add up all Digits Within a Cell with a Line Break
 Register FAQ Search Today's Posts Mark Forums Read

#1
06-08-2017, 01:35 AM
 Willy Excel Mac OS X Office 2016 for Mac Novice Join Date: Jun 2017 Posts: 3
Add up all Digits Within a Cell with a Line Break

Greetings! How do you SUM all numbers within a cell with line breaks?

Or: is it possible to highlight the cells and show "Sum:" down bottom?

Column has some cells with no number, some with one number, some with one number on top (line break) and one on bottom.
Attached Files
 SUMMultipleRowsWithinCells.xlsx (18.8 KB, 3 views)
#2
06-08-2017, 03:36 AM
 xor Windows 10 Office 2016 Expert Join Date: Oct 2015 Posts: 909

Maybe like the attached.
Attached Files
 SUMMultipleRowsWithinCells_2.xlsm (12.8 KB, 8 views)
#3
06-09-2017, 01:05 AM
 Willy Excel Mac OS X Office 2016 for Mac Novice Join Date: Jun 2017 Posts: 3

Thank you very much, xor. I see yours has macros. Ideally, I'll use a regular formula (and I was able to just have a gentleman help me create one). Nonetheless, helpful people like you make these computer headaches a breeze!
#4
06-09-2017, 01:52 AM
 xor Windows 10 Office 2016 Expert Join Date: Oct 2015 Posts: 909

I understand you already have a regular formula solution, but for others it might be useful to know one possible regular formula:

=SUM(IFERROR(--(0&MID(D4,ROW(INDIRECT("1:"&LEN(D4))),1)),0))

This is an array formula which must be committed by holding down Ctrl and Shift before pressing Enter.
#5
06-09-2017, 07:28 AM
 NoSparks Windows 7 64bit Office 2010 64bit Excel Hobbyist Join Date: Nov 2013 Location: British Columbia, Canada Posts: 650

Willy's cross post is here.
#6
06-09-2017, 09:49 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,222

Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
#7
07-09-2017, 12:51 AM
 Willy Excel Mac OS X Office 2016 for Mac Novice Join Date: Jun 2017 Posts: 3

Apologies for the cross post etiquette. Appreciate all the help! I have a solution that now works.

Can't see how to edit first post anymore. Other links:
https://www.excelforum.com/excel-for...ngle-cell.html
https://www.mrexcel.com/forum/excel-...ml#post4863554

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post skan Word 2 01-20-2017 03:50 AM nmss18 Word 2 09-11-2014 06:07 AM jadess916 Excel 1 06-26-2014 03:48 AM Glynda Mail Merge 1 04-08-2011 12:17 AM Learner7 Excel 3 08-10-2010 04:06 AM

All times are GMT -7. The time now is 05:13 PM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top