I will have column information that will list entries like this:
DD, DD9, SD, LHR, HIGHLIFT
BOTTOM SECTION, DD, D9
DD, PVC DD, SD, LHR, HIGHLIFT
Is there a way to run a SUMIF or other formula on these and separate the values from the commas? I am familiar with Text to Columns but I will be...