Hi there

I have a set of data. Each topic/subject has multiple entries. Adjacent to each topic is a number.

I need the countif formula to look for all 'common' words and to sum all the figures in the adjacent cells:

countif.xlsx