Thread: Add up all Digits Within a Cell with a Line Break
View Single Post
 
Old 06-08-2017, 01:35 AM
Willy Excel Willy Excel is offline Mac OS X Office 2016 for Mac
Novice
  
Join Date: Jun 2017
Posts: 3
Willy Excel is on a distinguished road
Default 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
File Type: xlsx SUMMultipleRowsWithinCells.xlsx (18.8 KB, 13 views)
Reply With Quote