Normally with the Sum If function you have the Sum column and the criteria column. For instance you want to average all the money made for Angelica: The name Angelica might be in Column A and the money in Column B. For my problem, however, I have them in the same cell. For instance, the cell reads---- "Angelica - $405".

How can I set a function to Sum all the cells that begin with "Angelica"?