Good afternoon. I have an excel spreadsheet with data pasted in from another source. Some cells have line breaks, with two rows of numbers. Using a simple method, how to:
1.) Highlight cells in column D and have it show "Sum:" at the bottom of the sheet (working for the cells with one number & no line break, but not for cells with line break and two rows of numbers).
and/or:
2.) SUM all numbers in each cell in column D and put that total in column H.
Much appreciated!SUMMultipleRowsWithinCells.xlsx
Bookmarks