I have a file that has a column with data in it. The data in these cells have Alt Enters, meaning some text is entered, then and Alt Enter to create a second line and then more text. There could be one line or two or three...
I have another column that has a field that contains (hopefully) some of the text in this first column somewhere in one of the cells. I need a formula that will look for this cells' data in that first column which has the Alt Enters and then sum the numbers in the second. Anyone have any ideas?
Sample attached.SUMIF Alt Enter.xlsx
Bookmarks